ExcelBanter - help!! 1000 appears as 10 in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - help!! 1000 appears as 10 in excel (https://www.excelbanter.com/excel-worksheet-functions/185137-help-1000-appears-10-excel.html)

Help!! 1000 appears as 10 in excel

help!! 1000 appears as 10 in excel

When I type 1000 it appears as 10. Can anyone help

Mike H

help!! 1000 appears as 10 in excel

Tools|Options|Edit
Un-Check
Fixed decimal places

Mike

"Help!! 1000 appears as 10 in excel" wrote:

When I type 1000 it appears as 10. Can anyone help

Gord Dibben

help!! 1000 appears as 10 in excel

ToolsOptionsEdit.

Uncheck "fixed decimal places"

Gord Dibben MS Excel MVP

On Fri, 25 Apr 2008 06:24:00 -0700, Help!! 1000 appears as 10 in excel <Help!!
1000 appears as 10 in wrote:

When I type 1000 it appears as 10. Can anyone help

All times are GMT +1. The time now is 07:45 AM.