Thread: How do I stop excel from changing single numbers like 1 into a de.
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default
Tools/Options/Calculation. Uncheck the Fixed Decimals checkbox.

In article ,
"Jendayii" wrote:

Every time i enter a number like 1 or 2 excel changes it to 0.001, 0.002
etc... in order to display 1 i have to enter 100. How do i fix this?
Reply With QuoteReply With Quote