Format 000-00000-00000-000 and recognize leading zeros in Excel?

[Jackie Kohlman]

[Peo Sjoblom]

Excel has only 15 digits precision so you can't use that as a numericial
format

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Jackie Kohlman" <Jackie [email protected]> wrote in message
news:[email protected]...
>

[Jackie Kohlman]

I need to keep the leading zeros and the hyphens. Is there a way to do this?

"Peo Sjoblom" wrote:

> Excel has only 15 digits precision so you can't use that as a numericial
> format
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey
>
>
> "Jackie Kohlman" <Jackie [email protected]> wrote in message
> news:[email protected]...
> >
>
>
>

[Dave Peterson]

preformat the cell as text and type all the 0's and hyphens

(or start your entry with an apostrophe:
'001-00234-00012-123


Jackie Kohlman wrote:
>
> I need to keep the leading zeros and the hyphens. Is there a way to do this?
>
> "Peo Sjoblom" wrote:
>
> > Excel has only 15 digits precision so you can't use that as a numericial
> > format
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> > Excel 95 - Excel 2007
> > Northwest Excel Solutions
> > www.nwexcelsolutions.com
> > "It is a good thing to follow the first law of holes;
> > if you are in one stop digging." Lord Healey
> >
> >
> > "Jackie Kohlman" <Jackie [email protected]> wrote in message
> > news:[email protected]...
> > >
> >
> >
> >

--

Dave Peterson

[Jackie Kohlman]

I am copying data from a SQL database into an excel ss. I must preformat the
cells of the ss that the data is being pasted to. This method still does not
keep the leading zeros. I am trying to eliminate the need to retype 4000+
numbers. Any suggestions?

"Dave Peterson" wrote:

> preformat the cell as text and type all the 0's and hyphens
>
> (or start your entry with an apostrophe:
> '001-00234-00012-123
>
>
> Jackie Kohlman wrote:
> >
> > I need to keep the leading zeros and the hyphens. Is there a way to do this?
> >
> > "Peo Sjoblom" wrote:
> >
> > > Excel has only 15 digits precision so you can't use that as a numericial
> > > format
> > >
> > > --
> > >
> > > Regards,
> > >
> > > Peo Sjoblom
> > >
> > > Excel 95 - Excel 2007
> > > Northwest Excel Solutions
> > > www.nwexcelsolutions.com
> > > "It is a good thing to follow the first law of holes;
> > > if you are in one stop digging." Lord Healey
> > >
> > >
> > > "Jackie Kohlman" <Jackie [email protected]> wrote in message
> > > news:[email protected]...
> > > >
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

[Dave Peterson]

Are you simply copying and pasting?

I've pasted into Notepad, saved that file, then used file|open to bring in that
data. I could specify text as the field type when I brought in that field.



Jackie Kohlman wrote:
>
> I am copying data from a SQL database into an excel ss. I must preformat the
> cells of the ss that the data is being pasted to. This method still does not
> keep the leading zeros. I am trying to eliminate the need to retype 4000+
> numbers. Any suggestions?
>
> "Dave Peterson" wrote:
>
> > preformat the cell as text and type all the 0's and hyphens
> >
> > (or start your entry with an apostrophe:
> > '001-00234-00012-123
> >
> >
> > Jackie Kohlman wrote:
> > >
> > > I need to keep the leading zeros and the hyphens. Is there a way to do this?
> > >
> > > "Peo Sjoblom" wrote:
> > >
> > > > Excel has only 15 digits precision so you can't use that as a numericial
> > > > format
> > > >
> > > > --
> > > >
> > > > Regards,
> > > >
> > > > Peo Sjoblom
> > > >
> > > > Excel 95 - Excel 2007
> > > > Northwest Excel Solutions
> > > > www.nwexcelsolutions.com
> > > > "It is a good thing to follow the first law of holes;
> > > > if you are in one stop digging." Lord Healey
> > > >
> > > >
> > > > "Jackie Kohlman" <Jackie [email protected]> wrote in message
> > > > news:[email protected]...
> > > > >
> > > >
> > > >
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[Saruman]

Go to Format, Cells, Custom

Type in the exact string you want with the zeros and the hyphens and click
ok

Any data entered will then be in that format

Saruman

----------------------------------------------------------------------------
---------
All Outgoing Mail Checked With Norton Antivirus 2003
----------------------------------------------------------------------------
---------

"Jackie Kohlman" <Jackie [email protected]> wrote in message
news:[email protected]...
>