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
|