ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 cell format - numbers (https://www.excelbanter.com/excel-discussion-misc-queries/206547-excel-2007-cell-format-numbers.html)

Musiclady

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.

Peo Sjoblom

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.




Musiclady

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