Format the cell as 00000000
--
David Biddulph

"frenchtoast" wrote in message
...
Hi David,

I tried the Data to Text command. This works except where the cells
contain
'00012345 it converted to 12345. I need to keep 00012345 displayed. Do
you
know how this can be done? (The vlookup worked).
Thank you.

"David Biddulph" wrote:

Why not try?
--
David Biddulph

"frenchtoast" wrote in message
...
I don't quite understand. Is A2 the cell with '12345? What is the
data/text
to column function?

The apostrophe in '12345 appears to be typed in (hence no error
message).

"David Biddulph" wrote:

=VALUE(A2)
or use Data/ Text to Columns.
--
David Biddulph

"frenchtoast" wrote in message
...
I have rows of data.

ie. '12345
and I want to use vlookup using number value 12345.

There isn't an error message (with pull-down arrow) to convert this
'12345
into a number.

How do I convert this without having to manually change these cells?

Thanks!