Input numbers appearing incorrectly on spreadsheet
 

When I type a number into excel the number appearing in the cell is divided
by 100.
i.e. if I input 1 the number in the cell is 0.01
but if I input 1.0 the number is correctly displayed as 1

Any ideas, it driving me to drink

Input numbers appearing incorrectly on spreadsheet
 

Try,

Tools|options|Edit
Un-Check fixed decimal places.

Mike

"Error in inputting numbers into excel" wrote:

When I type a number into excel the number appearing in the cell is divided
by 100.
i.e. if I input 1 the number in the cell is 0.01
but if I input 1.0 the number is correctly displayed as 1

Any ideas, it driving me to drink

Input numbers appearing incorrectly on spreadsheet
 

ToolsOptionsEdit.

Clear the checkbox at "Fixed Decimal Places"


Gord Dibben MS Excel MVP

On Fri, 7 Mar 2008 00:25:01 -0800, Error in inputting numbers into excel <Error
in inputting numbers into wrote:

When I type a number into excel the number appearing in the cell is divided
by 100.
i.e. if I input 1 the number in the cell is 0.01
but if I input 1.0 the number is correctly displayed as 1

Any ideas, it driving me to drink