I cannot replicate your problem using a pre-formatted cell or by preceding with
an apostrophe.

I can if I enter the data then format to text

Do not re-format after you have typed in the text.

Pre-format prior to entering the text 1234 1234 1234 1234

If you are entering the spaces as above you don't even need to pre-format or add
the apostrophe


Gord

On Tue, 15 May 2007 19:48:02 -0700, Dr Alok Modi MD
wrote:

Thanks Gord
That ! did the job. But fromatting the text as text converts the data as
something like this 12E + something.

Thanks
Dr Alok Modi MD