Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format cell problem | Excel Discussion (Misc queries) | |||
Cell format problem | Excel Discussion (Misc queries) | |||
Format of a cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
cell format problem | Excel Discussion (Misc queries) |