Inserting Number
 

How do i insert number "Zero 0" in front of multiple numbers
7775644619
7764856857
7932085127
7828206664
7917806074
7973667607


Thanks

Karen

Inserting Number
 

Custom format (FormattingCellsCustom) of 00000000000

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Karen" <poppy.com wrote in message
...
How do i insert number "Zero 0" in front of multiple numbers
7775644619
7764856857
7932085127
7828206664
7917806074
7973667607


Thanks

Karen

Inserting Number
 

This appears to work but the zero does not actually exsist ie not in FX Box
when copy and paste it does show zero,


Thanks

Karen



"Bob Phillips" wrote in message
...
Custom format (FormattingCellsCustom) of 00000000000

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Karen" <poppy.com wrote in message
...
How do i insert number "Zero 0" in front of multiple numbers
7775644619
7764856857
7932085127
7828206664
7917806074
7973667607


Thanks

Karen

Inserting Number
 

Then it won't be a number that Excel recognizes as a number, it would be
text. You can use a help column for that

=TEXT(A1,"00000000000")


copy as needed, then copy and paste special as values

--
Regards,

Peo Sjoblom



"Karen" <poppy.com wrote in message
...
This appears to work but the zero does not actually exsist ie not in FX
Box
when copy and paste it does show zero,


Thanks

Karen



"Bob Phillips" wrote in message
...
Custom format (FormattingCellsCustom) of 00000000000

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Karen" <poppy.com wrote in message
...
How do i insert number "Zero 0" in front of multiple numbers
7775644619
7764856857
7932085127
7828206664
7917806074
7973667607


Thanks

Karen

Inserting Number
 

Your data must be Text numbers not actual numbers.


Data Text to Columns Next Next Finish

Custom Format cells as 00000000000


"Karen" wrote:

This appears to work but the zero does not actually exsist ie not in FX Box
when copy and paste it does show zero,


Thanks

Karen



"Bob Phillips" wrote in message
...
Custom format (FormattingCellsCustom) of 00000000000

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Karen" <poppy.com wrote in message
...
How do i insert number "Zero 0" in front of multiple numbers
7775644619
7764856857
7932085127
7828206664
7917806074
7973667607


Thanks

Karen

Inserting Number
 

Karen

The formatting just changes the appearance, not the value.

If you want the value changed you could use a helper cell with a formula.

="0" & A1

Drag/copy down then CopyPaste SpecialValuesOKEsc.

The values are now text with a preceding 0


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 15:29:59 +0100, "Karen" <poppy.com wrote:

This appears to work but the zero does not actually exsist ie not in FX Box
when copy and paste it does show zero,


Thanks

Karen



"Bob Phillips" wrote in message
...
Custom format (FormattingCellsCustom) of 00000000000

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Karen" <poppy.com wrote in message
...
How do i insert number "Zero 0" in front of multiple numbers
7775644619
7764856857
7932085127
7828206664
7917806074
7973667607


Thanks

Karen