excel-enter integer number and get two decimal places

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

Guest

when i enter an integer in a cell the resulting number has 2 decimals. Can
you help? Thank you.
 
Tools>options>edit and uncheck fixed decimal places

--
Regards,

Peo Sjoblom

(No private emails please)
 

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

Access stripping decimal places in query 1
More than two decimal places 1
Numbers changing between sheets 13
integers entered are converted into decimal places e.g. 1 = 0.01 1
Help with fixed decimal 4
Excel 2007 adding a column of negative and positive number 2
Problem with Excel rounding numbers 5
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1

Back
Top