Rightclick on the cell, click on format, and change it from scientific to
General, or Number.

--
kassie

never stop learning




"Elisabeth" wrote in message
...
How can I convert a number 1,234E+06 into 1234000 without having to
rewrite
all the values in my dataset?