Problem: zeroes added to "general" format cell
 

Hi to all.
In a pc with XP installed, pressing enter after entering 1, the result
is 100. Two zeroes are added automatically.
Selecting "Format"- "Cells" I found:
Category=General

No macro is present. How can I avoid this strange behaviour?
Any suggestion will be well appreciated.

Regards,

Giovanni


--
gio123bg
------------------------------------------------------------------------
gio123bg's Profile: http://www.excelforum.com/member.php...fo&userid=4892
View this thread: http://www.excelforum.com/showthread...hreadid=553546

Problem: zeroes added to "general" format cell
 

Goto ToolsOptions and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gio123bg" wrote in
message ...

Hi to all.
In a pc with XP installed, pressing enter after entering 1, the result
is 100. Two zeroes are added automatically.
Selecting "Format"- "Cells" I found:
Category=General

No macro is present. How can I avoid this strange behaviour?
Any suggestion will be well appreciated.

Regards,

Giovanni


--
gio123bg
------------------------------------------------------------------------
gio123bg's Profile:
http://www.excelforum.com/member.php...fo&userid=4892
View this thread: http://www.excelforum.com/showthread...hreadid=553546

Problem: zeroes added to "general" format cell
 

:) Thanks for the quick reply!!!! The problem is solved!

Bye
Giovanni


--
gio123bg
------------------------------------------------------------------------
gio123bg's Profile: http://www.excelforum.com/member.php...fo&userid=4892
View this thread: http://www.excelforum.com/showthread...hreadid=553546