Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changes figures automatically
I am using MS Excel 2002, but of recent when i enter a figure (number) it either cuts it or changes to decimal points automatically. Example: When I enter 7000000 changes it to 7000, when I enter 4020 changes it to 4.20 and when I enter 23% changes to 350%. What could be problem? andthe solution Regards -- mabvuto ------------------------------------------------------------------------ mabvuto's Profile: http://www.excelforum.com/member.php...o&userid=31891 View this thread: http://www.excelforum.com/showthread...hreadid=516174 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changes figures automatically
Tools|Options|edit tab
uncheck Fixed Decimal places This is used when someone wants to do a lot of data entry, but doesn't want to type the decimal point. Although, I'm confused about 23% changing to 350%. mabvuto wrote: I am using MS Excel 2002, but of recent when i enter a figure (number) it either cuts it or changes to decimal points automatically. Example: When I enter 7000000 changes it to 7000, when I enter 4020 changes it to 4.20 and when I enter 23% changes to 350%. What could be problem? andthe solution Regards -- mabvuto ------------------------------------------------------------------------ mabvuto's Profile: http://www.excelforum.com/member.php...o&userid=31891 View this thread: http://www.excelforum.com/showthread...hreadid=516174 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changes figures automatically
Solution: Tools | Options; open Edit tab; uncheck Fixed Decimal
I hope you had a few typos in the message: 7000000 changes it to 7000 (ok) 4020 changes it to 4.20 (do you mean 4.02%) 23% changes to 350% (this is mystery - has someone played with Autocorrect?) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mabvuto" wrote in message ... I am using MS Excel 2002, but of recent when i enter a figure (number) it either cuts it or changes to decimal points automatically. Example: When I enter 7000000 changes it to 7000, when I enter 4020 changes it to 4.20 and when I enter 23% changes to 350%. What could be problem? andthe solution Regards -- mabvuto ------------------------------------------------------------------------ mabvuto's Profile: http://www.excelforum.com/member.php...o&userid=31891 View this thread: http://www.excelforum.com/showthread...hreadid=516174 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can you automatically insert next sequential number in an excel fo | Excel Discussion (Misc queries) | |||
The Excel cells are not automatically calc. existing formula. | Excel Worksheet Functions | |||
program excel worksheet to automatically not print blank rows | Excel Worksheet Functions | |||
In Excel how can a number automatically display in text form | Excel Worksheet Functions |