digit in a cell

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

Guest

Each time I enter a numeric, like "1" or "2". The cell defaults to "0.001"
and "0.002" and so on. Until I type "100" returns "1". Please advise me how
to restore to true number exactly what I type? Thanks.
 

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

How do I stop excel from changing single numbers like 1 into a de. 1
'Smart' Deletion 1
return the Cell address of a value 3
Reference to another worksheet cell in a sumproduct formula 1
Excel automatically dividing value by 100... 2
Excel automatically deviding value by 100... 1
Excel VBA 1
To extract the number if there is niumeric in right most digits 4

Back
Top