 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Value in list wont show same amount of numbers.
I have a list of values. For some reason, I cant get one of the values to display the same amount of numbers as the others in the list. I have tried manually changing the cell format, as well as performing the paste special - operation, add procedure. The actual number is:530911.0010 (with the zero on the end) I am performing a vlookup on the list so I need them all uniform. Any clues? 530720.0000 530810.0000 530911.001 530919.0090 530921.4090 540233.6000 540331.0040 How did you get the others to show those trailing 0's--especially the 530720.0000? Did you format the cell as text and then type in the number? Did you start your data entry with an apostrophe: '530720.0000 Or did you give the cell a custom number format: Format|Cells|Number tab|Custom category 000000.0000 With =vlookup(), it's not really what's displayed in the cell--it's the value that the cell contains. And if the values are really numbers, then 530720.0000 = 530720 and 530911.0010 = 530911.001 > I have a list of values. For some reason, I cant get one of the values > to display the same amount of numbers as the others in the list. I [quoted text clipped - 14 lines] > 540233.6000 > 540331.0040  SignatureDave Peterson Thanx Mr. Dave, I just tried this.... With an added apostrophe before the number, I typed the value with the last zero in another cell. I then copied and used paste special, pasted that value into the list where the 'crazy' value was and its all uniform now. Thanx for mentioning the apostrophe question. I guess it was reading like text. That helped me figure out what may happened. Thanx again! I think I owe you a Krystal for helping me before.... So now Sir, when I make my first million, you can make that a DOUBLE cheese krystal (or White Castle Burger)!! Next time I'm out with Harold and Kumar, we'll stop by for some sliders! > Thanx Mr. Dave, > [quoted text clipped - 14 lines] > I make my first million, you can make that a DOUBLE cheese krystal (or > White Castle Burger)!! SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.