Value 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

Dave
Wed May 07 18:20:52 CDT 2008

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



"J.W. Aldridge" wrote:
>
> 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

--

Dave Peterson

J
Thu May 08 16:20:30 CDT 2008

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

Dave
Thu May 08 17:54:40 CDT 2008

Next time I'm out with Harold and Kumar, we'll stop by for some sliders!

"J.W. Aldridge" wrote:
>
> 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)!!

--

Dave Peterson