The formatting solution will change how the number appears but the large
value is stilled stored in the cell.
The actually change the value, put 1000000 in an empty cell and copy it;
select all the cells to be treated; use menu command Edit | Paste Special
and click the Divide box; click OK
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Fawn" wrote in message
...
I have a data sheet that has data that is in the millions. Instead of
having a number show as 302,000,000. is it possible to have it show as 302
without retyping it.

Please let me know

Thanks