excel format errors

  • Thread starter Thread starter bcrace
  • Start date Start date
B

bcrace

whenever I put an integer value in a new worksheet, it
takes my value and divides it by 10,000. For example, if
I enter 34, it returns .00034. If I enter 34.0, it
returns 34. All cells are formatted as General, with no
indication of any special formatting applied to them.
This has happened not only on my machine but also on
several other machines around here.
 
Tools > Options > Edit tab and uncheck the "Fixed
Decimals" box.

HTH
Jason
Atlanta, GA
 
brace,

Have a look at Tools | Options | Edit | Fixed Decimal

Uncheck the box, and you will have the behaviour your expect.

Regards,
Kevin
 
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

Conditional formatting in Excel 2010 2
Remove date format? 3
copy value 3
Excel - Formatting 8
Base 60 input 7
Excel is dividing my entries...why?? 1
Date Format 1
numeric entered automatically divided 100! 1

Back
Top