On Feb 23, 8:34 pm, SteveW wrote:
Nothing wrong, but there is a setting for the the current Workbook (and it
affects all open ones as well)

Tools - Options - Edit tab

Fixed Decimal - uncheck the box

This is only useful if you have a lot of fixed decimal data to enter
Which can be done without having to enter the .

Best to only use it when absolutley necessary, and turn it off afterwards.

Steve

kOn Fri, 23 Feb 2007 18:26:42 -0000, wrote:



When I enter a number in a cell,Excelsomehow divides the number by
100 ie. entering 1234 gets a value of 12.34 in the cell.

What have I done wrong.

enenko- Hide quoted text -

- Show quoted text -

Thanks! That did it!!
enenko