![]() |
Excel 2007 cell format - numbers
How do I keep Excel from adding "0" to numbers? When I type "7" it returns
"70000000000000" I tried using the accounting, currency, and number cell format but nothing worked. |
Excel 2007 cell format - numbers
Office buttonexcel optionsadvanced and clear "automatically insert a
decimal point" It looks like someone joked with you -- Regards, Peo Sjoblom "Musiclady" wrote in message ... How do I keep Excel from adding "0" to numbers? When I type "7" it returns "70000000000000" I tried using the accounting, currency, and number cell format but nothing worked. |
Excel 2007 cell format - numbers
I can't believe it was that simple! Thank you very much.
I was able to fix other small issues also, again thank you. "Peo Sjoblom" wrote: Office buttonexcel optionsadvanced and clear "automatically insert a decimal point" It looks like someone joked with you -- Regards, Peo Sjoblom "Musiclady" wrote in message ... How do I keep Excel from adding "0" to numbers? When I type "7" it returns "70000000000000" I tried using the accounting, currency, and number cell format but nothing worked. |
All times are GMT +1. The time now is 08:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com