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