ExcelBanter - Nmber entering

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

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

- - Nmber entering (https://www.excelbanter.com/excel-discussion-misc-queries/13986-nmber-entering.html)

jyh

Nmber entering

When I enter a number, it enters n/100, i.e. 1 becomes .01. I can't find
anything wrong in formatting.

Dave Peterson

Tools|options|Edit tab|Uncheck Fixed decimal places

jyh wrote:

When I enter a number, it enters n/100, i.e. 1 becomes .01. I can't find
anything wrong in formatting.

--

Dave Peterson

Gord Dibben

ToolsOptionsEdit. Uncheck "Fixed Decimal Places".

Gord Dibben Excel MVP

On Fri, 18 Feb 2005 17:19:01 -0800, jyh wrote:

When I enter a number, it enters n/100, i.e. 1 becomes .01. I can't find
anything wrong in formatting.

All times are GMT +1. The time now is 04:14 PM.