when I enter 5000 the spreadsheet shows 500. Why?

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

Guest

When I enter the number 5000 It comes up 500. any help out there? Thanks
 
Look under tools>options>edit and uncheck fixed decimal places


Regards,

Peo Sjoblom
 
Check Tools>Options>Edit and make sure the Fixed decimal box is unchecked.
 
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

copy multiple records based on criteria or total amount 22
Sum data by date range 1
Roundup/Rounddown/Mround/IF statement? 8
Excel 2002: How to lookup the last number and text in a column ? 3
Searching for numbers, do I enter the , or leave it out? 2
A formula in this worksheet contains one or more invalid reference 1
Collate data from one spreadsheet into another spreadsheet 2
Report Format - Pivot Table not working 2

Back
Top