cells are automatically dividing each # I put in by 10!!!

[Romileyrunner1]

Hi,
for some reason, every time I put a number in any cell, it is automatically
didvide by 10!???
EG, type in 5, get 0.5
Put in 50, get 5!!!

Weird and very annoying!!!!!!
Everything else seems to be working fine.
Can put numbers in fine i formulas, so am guessing it isn`t the keyboard,
but not certain.

Anyone had the same problem or better still SOLUTION?

Thanks guys.

 

[Eduardo]

Hi,
check the cell format to be sure that has not an special format, go to the
cell, right click on the mouse, cell format, number

if this helps please click yes

 

[T. Valko]

Check this setting....

In Excel 2007:

Office button>Advanced>Editing Options>Automatically insert a decimal point

Other versions of Excel:

Tools>Options>Edit tab>Fixed decimal places

 

[T. Valko]

Ooops!

In Excel 2007:
Office button>Advanced>Editing Options>Automatically insert a decimal point

Should be:

Office button>Excel Options>Advanced>Editing Options>Automatically insert a
decimal point

 

[Romileyrunner1]

WHOO HOOO! That was it T. VALKO!
Don`t know how I did it in the first place, but you were bang on mate; I had
an automatic seting of 1 DP switched on. What a relief. I thought my keyboard
had a ghost!
Thanks a million.
Keep up the good work.

 

[T. Valko]

You're welcome. Thanks for the feedback!