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: