Cell Entries show as decimal

  • Thread starter Thread starter Guest
  • Start date Start date
Sounds like you've set fixed decimal places.

Goto Tools>Options>Edit tab>uncheck Fixed decimal places>OK
 
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

Data Validation - Complex Q 2
IF OR ??? 1
Very Peculiar DV error Q 9
Look up Data by Row criteria and column criteria 2
Multi area Array using IRR function 2
Vlookup 5
Problem calculating 3
2 Data Validations Q 7

Back
Top