G
Govind
Go to Format cells and use custom format and use this format
"###,,"
Govind.
"###,,"
Govind.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Fawn
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
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
B
Bernard Liengme
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
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
M
Mark B via OfficeKB.com
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!
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!