i did something wrong

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

Guest

Good afternoon,
i must have hit something in the options or format, I have a spread sheet
and when entering numbers, it now will take my number (175) and goes to 1.75,
tried changing the cells format to no decimal places and now just puts a 2
there, any ideas where I went wrong, all I want is regular numbers as I
entered 175
 
In Excel, click on Tools | Options | Edit | uncheck the "Fixed
decimal places" box | OK.
 

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

problem with fractions to decimal 1
How do I prevent the cell from changing the number I enter? 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
enter date in column a and amount in column d 2
Excel 2003 & Fixed Decimal Places 3
Your entry cannot be used. An integer or decimal number may be req 3
Numbers turn into something different after I push enter 3
How do I type a # (01020) in Excel & have the 1st 0 stay? 5

Back
Top