Problem: zeroes added to "general" format cell

  • Thread starter Thread starter gio123bg
  • Start date Start date
G

gio123bg

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
 
Goto Tools>Options 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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula result is zero but zero is not populating in cell 3
Format cells to General? 1
Conditional formatting on a dynamic range - workaround 1
Zero in cell where it is linked to a blank cell 7
Zero-Length string vs Zero (also a valid value) 2
formatting numbers beginning with zero 6
formula cell format change 3
Why do the general and number cell formats not work correctly? 1

Back
Top