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