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