Excel Number Entry Problem

  • Thread starter Thread starter TheRobSter
  • Start date Start date
T

TheRobSter

I am using Excel in Office 2000. When I enter in a number such as 400
it will automatically reduce it to 40 in the cell. The last number i
always dropped off. How do I correct this? I have even trie
reinstalling Excel to see if that would help, but have had no luck
Could this be a virus? Please help
 
Go to the Tools menu, choose Options, then the Edit tab. There,
uncheck the "Fixed Decimal" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


TheRobSter said:
I am using Excel in Office 2000. When I enter in a number such as 400,
it will automatically reduce it to 40 in the cell. The last number is
always dropped off. How do I correct this? I have even tried
reinstalling Excel to see if that would help, but have had no luck.
Could this be a virus? Please help!


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide
Click to expand...
to creating financial statements
 

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

Default number format in Excel 1
Excel Visual Basic to get current row number 1
How do I set up an automatic invoice number in Excel 2007 1
"Bug" in number format for long number entries? 7
Need a formula for a descimal integer into a whole number 1
Duplicate Entries 3
I cannot enter a number containing more than 15 digits in Excel 1
Excel Query setup 0

Back
Top