Peo wrote on Mon, 10 Nov 2008 09:29:59 -0800:

000 000 0000

assuming the number of digits are constant

any other way would require an event macro

Of course, if you are willing to have the text numbers in A and another
column, say B, formatted 000 000 0000, you could make, say,
B1=VALUE(A1).

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not