When i enter 10000 in a cell it is showing only 100

S

Satyender

Hi There !

I am clue less exactly what happend to my Excel.
When ever i enter a numerical value Say 10000 it is showing 100
if i enter100 it is showing 1

Could some one can suggest a remedy please....
 
G

garfield-n-odie [MVP]

In Excel, click on Tools | Options | Edit | uncheck the "Fixed
decimal places" box | OK.
 

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

Weigh tasks 0
Scroll does not show preview 0
Numbers automatcally divided by 100 when typed in 1
VLookup or Macro? 0
Show Ink Excel 0
Numerical data does not appear as entered 4
Sub projects added as read only in Master file which are saved on sharepoint 1
Relevant user should see only his data 0

Top