Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gio123bg
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gio123bg
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format cell problem Murat Gordeslioglu Excel Discussion (Misc queries) 2 June 7th 06 02:39 PM
Cell format problem Barb Excel Discussion (Misc queries) 6 March 6th 06 08:31 PM
Format of a cell profG Excel Discussion (Misc queries) 1 January 16th 06 03:02 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
cell format problem kumarappans Excel Discussion (Misc queries) 3 November 26th 04 05:36 PM


All times are GMT +1. The time now is 03:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"