software

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: www.excelforum.com/member.php...oamp;userid=31891
View this thread: www.excelforum.com/showthread...hreadid=516174Tools|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:
gt;
gt; I am using MS Excel 2002, but of recent when i enter a figure (number)
gt; it either cuts it or changes to decimal points automatically.
gt;
gt; Example: When I enter 7000000 changes it to 7000, when I enter 4020
gt; changes it to 4.20 and when I enter 23% changes to 350%.
gt;
gt; What could be problem? andthe solution
gt; Regards
gt;
gt; --
gt; mabvuto
gt; ------------------------------------------------------------------------
gt; mabvuto's Profile: www.excelforum.com/member.php...oamp;userid=31891
gt; View this thread: www.excelforum.com/showthread...hreadid=516174

--

Dave Peterson

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

quot;mabvutoquot; gt; wrote in
message ...
gt;
gt; I am using MS Excel 2002, but of recent when i enter a figure (number)
gt; it either cuts it or changes to decimal points automatically.
gt;
gt; Example: When I enter 7000000 changes it to 7000, when I enter 4020
gt; changes it to 4.20 and when I enter 23% changes to 350%.
gt;
gt; What could be problem? andthe solution
gt; Regards
gt;
gt;
gt; --
gt; mabvuto
gt; ------------------------------------------------------------------------
gt; mabvuto's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31891
gt; View this thread: www.excelforum.com/showthread...hreadid=516174
gt;