Number Formatting

Hello

I having a bit of trouble entering numbers in Excel, every time I try to enter a number it seems to divide it by 100. For example : - 1 entered in to a cell becomes 0.01, 100 becomes 1....etc. I've tried formatting the cells and had no luck, tried Tool>Options but not sure where to look.

Any help is appreciated.

Many thanks.

Hi

Check in Tools>Options>Edit tab and uncheck Fixed Decimal Places

Richard