Re: Number with leading zeros

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 02/02/04 

Date: Mon, 2 Feb 2004 16:47:43 -0000

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)
"SteveM" <anonymous@discussions.microsoft.com> wrote in message
news:88b301c3e9aa$72574560$a001280a@phx.gbl...
> Thanks Bob
>
> I tried this but the number of zeros very.  Is there a
> wild card?
>
> Steve
> >-----Original Message-----
> >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" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:7dff01c3e943$954c44b0$a101280a@phx.gbl...
> >> 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?
> >>
> >
> >
> >.
> >
Loading