ExcelBanter - Data Entry problem

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

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

- - Data Entry problem (https://www.excelbanter.com/excel-discussion-misc-queries/54647-re-data-entry-problem.html)

Ray A

Data Entry problem

one way;
Ctrl+A to select the entire sheet. Then formatcellsnumber tab
Alternative;
ToolsoptionsEdit tabuncheck the fixed decimals box
HTH

"Bob Shepard" wrote:

When I enter numbers into spreadsheets they get changed to two decimal points
(e.g. 250 = 2.5). I know there must be some global setting, but I don't know
where. Can anyone help?

All times are GMT +1. The time now is 06:46 AM.