Thread
:
Input numbers appearing incorrectly on spreadsheet
View Single Post
#
3
Posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
Posts: 22,906
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
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben