ExcelBanter - Excel number format

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

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

- - Excel number format (https://www.excelbanter.com/excel-discussion-misc-queries/152196-excel-number-format.html)

Murray

Excel number format

I am using Excel 2003. When I enter a number into a cell, it automatically
divides by 100 and displays in this format. eg 23 displays as 0.23. I have
formatted the cells as general format.

Mike H

Excel number format

Try,

Tools|options|edit

uncheck fixed decimal places.

Mike

"Murray" wrote:

I am using Excel 2003. When I enter a number into a cell, it automatically
divides by 100 and displays in this format. eg 23 displays as 0.23. I have
formatted the cells as general format.

Murray

Excel number format

Many thanks - this has done the trick!

"Mike H" wrote:

Try,

Tools|options|edit

uncheck fixed decimal places.

Mike

"Murray" wrote:

I am using Excel 2003. When I enter a number into a cell, it automatically
divides by 100 and displays in this format. eg 23 displays as 0.23. I have
formatted the cells as general format.

David Biddulph[_2_]

Excel number format

Tools/ Options/ Edit:
Unset "Fixed decimal places".
--
David Biddulph

"Murray" wrote in message
...
I am using Excel 2003. When I enter a number into a cell, it automatically
divides by 100 and displays in this format. eg 23 displays as 0.23. I
have
formatted the cells as general format.

All times are GMT +1. The time now is 06:59 PM.