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

  • Thread starter Thread starter Romileyrunner1
  • Start date Start date
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.
 
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
 
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
 
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
 
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.
 
Back
Top