ExcelBanter - Cell Input ~ Display

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

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

- - Cell Input ~ Display (https://www.excelbanter.com/excel-discussion-misc-queries/150370-cell-input-%7E-display.html)

Ronnie

Cell Input ~ Display

Help! When inputting a number (i.e. 2) into a cell it displays as 0.02 ~ if
222 is entered it displays 2.22 this is whether the cell is formatted as
General, Number or Currency ~ Currency displays £0.02. Have checked Regional
& Language Options the Excel Options and all seems OK.

Regards
Ronnie
Email:

Mike H

Cell Input ~ Display

try.

Tools|options|edit

uncheck fixed decimal places

Mike

"Ronnie" wrote:

Help! When inputting a number (i.e. 2) into a cell it displays as 0.02 ~ if
222 is entered it displays 2.22 this is whether the cell is formatted as
General, Number or Currency ~ Currency displays £0.02. Have checked Regional
& Language Options the Excel Options and all seems OK.

Regards
Ronnie
Email:

Ronnie

Cell Input ~ Display

Hi Mike,

It worked

Sincere Thanks

Ronnie

"Mike H" wrote:

try.

Tools|options|edit

uncheck fixed decimal places

Mike

"Ronnie" wrote:

Help! When inputting a number (i.e. 2) into a cell it displays as 0.02 ~ if
222 is entered it displays 2.22 this is whether the cell is formatted as
General, Number or Currency ~ Currency displays £0.02. Have checked Regional
& Language Options the Excel Options and all seems OK.

Regards
Ronnie
Email:

All times are GMT +1. The time now is 01:57 PM.