Number with leading zeros

[SteveM]

I am copying numbers with leading zeros into excel. I
then need to import it to access. I am having a hard
time getting the numeric value, with the leading zeros,
to convert. I need the leading zeros. I have tried
formatting the cells to text, general, and custom. I
have tried copying and pasting values into formatted
fields. This is driving me crazy.

What's worse is the some cells do convert and some
don't. Is there any way to force a format, or at least
see what the "real" format of the data is?

 

[Bob Phillips]

Steve,

Format is only part of presentation, not it's real value. To get real values
with leading zeroes, use

=TEXT(A1,"00000000")

in a separate column, or however many zeroes you want, and then export that
column to Access.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[SteveM]

Thanks Bob

I tried this but the number of zeros very. Is there a
wild card?

Steve

 

[Bob Phillips]

Steve,

Which part varies, the input or the output? I think you have a problem here
as there is no information on what the number of zeroes should be.

How are you doing the copy, and where is the data sourced from?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)