ExcelBanter - excel

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel (https://www.excelbanter.com/excel-discussion-misc-queries/90958-excel.html)

ballhawk

excel

Why when I type in 5000 in Excel does only the number 5 show up? I have the
format set to general.

Gord Dibben

excel

Go to ToolsOptionsEdit and uncheck "fixed decimal places"

Gord Dibben MS Excel MVP

On Sat, 27 May 2006 15:54:01 -0700, ballhawk
wrote:

Why when I type in 5000 in Excel does only the number 5 show up? I have the
format set to general.

ballhawk

excel

Than you very much! It works fine now.

"ballhawk" wrote:

Why when I type in 5000 in Excel does only the number 5 show up? I have the
format set to general.

All times are GMT +1. The time now is 02:10 AM.