View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.