Go to Format cells and use custom format and use this format

"###,,"

Govind.

Fawn wrote:

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

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

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

Another way, assuming you want to input the data in actual, and merely view
it later with just the millions showing is to create a new sheet (further
assumtion is that your data is on sheet1, starting at cell A1)

=LEFT(Sheet1!A1,LEN(Sheet1!A1)-6

the minus 6 at the end will take 6 digits off the right of your number- so if
you want to display less, make it 7, or 8, etc... Hope that helps (my first
post here)!! Good Luck!

Fawn wrote:
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


--
Message posted via http://www.officekb.com