how do i remove conversion of 0.001 into 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when i put any numeric value in excell it is displayed in fractional mode for
eg. 1 is displayed as 0.001
 
Go to Tools>Options>Edit and uncheck the Fixed Decimal checkbox.

--

HTH

RP
(remove nothere from the email address 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

1 is converted in 0.001 in all excell files 2
Question regarding inserting rows and data. 1
why do zero dollar values sometimes show red? 7
Conditional formula - dealing with < numbers as numeric fields 1
How do I stop excel from changing single numbers like 1 into a de. 1
Ascii file reading VB Express 2010 2
How to divide a number with "less than" sign? ie: <1/1000 = <0.001 3
Display decimal with multiplier 1

Back
Top