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

R

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.
 
E

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

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

T. Valko

Ooops!
In Excel 2007:
Office button>Advanced>Editing Options>Automatically insert a decimal point
Click to expand...

Should be:

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

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.
 
Top