Cell disply 0.0001 for 1... anybody solve this problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shashidharga - 01 Oct 2004 18:16 GMT

Hi every body
I'm a new member to this forum.
I've a prbleb. In Excel 2002, if I type a value 1 in any of the cell,
the cell displays 0.0001 and for 2 it'll display 0.0002 and if I type
100 it'l display .01, but if I type 1. it will display 1. Why it is
happening ? Any body please tell me how to overcome this problem

Signature

shashidharga

Reply to this Message

kkknie - 01 Oct 2004 18:24 GMT

Under Tools menu, select Options. Go to the Edit tab and uncheck th
fixed decimal places. It's basically a thing for accountants (set a
2) so they don't have to enter a decimal point for every currenc
entry.

Reply to this Message

Frank Kabel - 01 Oct 2004 18:25 GMT

Hi
goto 'Tools - Options - Edit' and uncheck 'Fixed decimals'

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Hi every body
> I'm a new member to this forum.
[quoted text clipped - 8 lines]
> shashidharga's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14922
> View this thread: http://www.excelforum.com/showthread.php?threadid=265562

Reply to this Message