decimal places

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

Guest

Hi I have a reasonably complex model in Excel, but for some unknown reason
the package will not recognise any number i type in with a decimal place.

e.g. recognises 3814 as a number, but not 3813.5,

any ideas???
 
Go to Format/Cells/Number/ and set your decimal places

Hope this help
 
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

IF statement re Minus vs Plus 0
Access stripping decimal places in query 1
how do I stop excel putting a space after a decimal point 1
Zeros after the decimal 7
Decimal point 4
More than two decimal places 1
How to retain decimal zeroes? 5
Incorrect result for simple SUM formula 9

Back
Top