=TEXT(A1,"0000 000 000")
--
David Biddulph

"enna49" wrote in message
...
Hi

Maybe I am expecting too much.

I have a field which has custom format 1234 000 000 OR 0000 000 000

After this field has been populated I want to copy and paste the data to
another column. Of course it only reads the figures I input, is there a
way
I can use the data that is created eg 1234 025 252 OR 0032 584 456

Thanks

Anne