Value in list wont show same amount of numbers.

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

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
 
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)!!
 
Back
Top