ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Stop decimal points in EXCEL....... (https://www.excelbanter.com/excel-worksheet-functions/121750-stop-decimal-points-excel.html)

Rob

Stop decimal points in EXCEL.......
 
How do I stop my spreadsheet from putting in decimal points?

I keep trying to type in numbers and all it wants to do is put in a decimal
point.

T. Valko

Stop decimal points in EXCEL.......
 
Do you have the cells formatted as NUMBER with a set number of decimal
places?

Or, check this setting:

ToolsOptionsEditFixed decimal places

Biff

"Rob" wrote in message
...
How do I stop my spreadsheet from putting in decimal points?

I keep trying to type in numbers and all it wants to do is put in a
decimal
point.





All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com