If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
number has bogus decimal points
I do the stats for a department and all of a sudden wierd things are
happening. Today, I logged on and went to enter some numbers in a spreadsheet I use monthly. However, when I typeds in "2" it dispalyed as .02. So, I checked the formatting, made sure it was on 'number' format and no decimal places. Typed in "2" and it now dispalys in cell as '0"! How do I get it to stop this. 2 should be 2 should be 2. In case this is an important clue: my boss said there were some errors in a stats workbook she needed and she asked me to look at it. One cell is a sum of numbers from other workbooks. Instead of the stat there was a VALUE thingy. It said that there was a problem with the formatting of one of the cells this product was pulling from. I had a lot of trouble figuring this one out and eventually just cut and pasted. What makes a cells format suddenly go wierd? |
#2
|
|||
|
|||
number has bogus decimal points
ToolsOptionsEdit, uncheck Fixed decimal
-- Kind regards, Niek Otten "Librarian" wrote in message ... I do the stats for a department and all of a sudden wierd things are happening. Today, I logged on and went to enter some numbers in a spreadsheet I use monthly. However, when I typeds in "2" it dispalyed as .02. So, I checked the formatting, made sure it was on 'number' format and no decimal places. Typed in "2" and it now dispalys in cell as '0"! How do I get it to stop this. 2 should be 2 should be 2. In case this is an important clue: my boss said there were some errors in a stats workbook she needed and she asked me to look at it. One cell is a sum of numbers from other workbooks. Instead of the stat there was a VALUE thingy. It said that there was a problem with the formatting of one of the cells this product was pulling from. I had a lot of trouble figuring this one out and eventually just cut and pasted. What makes a cells format suddenly go wierd? |
#3
|
|||
|
|||
number has bogus decimal points
Tools Options Edit and clear the fix decimal checkbox
-- Gary's Student "Librarian" wrote: I do the stats for a department and all of a sudden wierd things are happening. Today, I logged on and went to enter some numbers in a spreadsheet I use monthly. However, when I typeds in "2" it dispalyed as .02. So, I checked the formatting, made sure it was on 'number' format and no decimal places. Typed in "2" and it now dispalys in cell as '0"! How do I get it to stop this. 2 should be 2 should be 2. In case this is an important clue: my boss said there were some errors in a stats workbook she needed and she asked me to look at it. One cell is a sum of numbers from other workbooks. Instead of the stat there was a VALUE thingy. It said that there was a problem with the formatting of one of the cells this product was pulling from. I had a lot of trouble figuring this one out and eventually just cut and pasted. What makes a cells format suddenly go wierd? |
#4
|
|||
|
|||
number has bogus decimal points
Click Tools Options Edit tab
Uncheck "Fixed Decimals" OK (It was probably checked to 2 dp) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Librarian" wrote in message ... I do the stats for a department and all of a sudden wierd things are happening. Today, I logged on and went to enter some numbers in a spreadsheet I use monthly. However, when I typeds in "2" it dispalyed as .02. So, I checked the formatting, made sure it was on 'number' format and no decimal places. Typed in "2" and it now dispalys in cell as '0"! How do I get it to stop this. 2 should be 2 should be 2. In case this is an important clue: my boss said there were some errors in a stats workbook she needed and she asked me to look at it. One cell is a sum of numbers from other workbooks. Instead of the stat there was a VALUE thingy. It said that there was a problem with the formatting of one of the cells this product was pulling from. I had a lot of trouble figuring this one out and eventually just cut and pasted. What makes a cells format suddenly go wierd? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Set number of decimal places in bookmark | Ray_Johnson | General Discussion | 2 | August 25th, 2005 09:29 PM |
Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
How to measure the distance between two lat and long points | A new kind of measurement | Running & Setting Up Queries | 6 | January 14th, 2005 04:45 PM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
reduce decimal places of number used in formula | CatzJ | General Discussion | 2 | November 16th, 2004 06:18 PM |