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
|
|||
|
|||
Format Cell Problem
Hi,
Sorry for all these dumb questions, but I never had any problems with Excel 97. This one is apparently just too complicated for me at my old age. Anyway, thanks for all the help; really appreciate it. So, using Excel 2007, and XP I select a cell that has a number in it with 5 decimal places. I go to Format Cells, and select Number, and tell it to go to 4 decimal places. It won't, and continues to show 5 decimal places. This is also true if I try it on a column of numbers. What am I not doing right ? (I am sure that what appears in the cell is truly a number, and not text.) Thanks, Bob |
#2
|
|||
|
|||
Format Cell Problem
Why are you sure the number is not text?
In an adjacent cell enter =ISNUMBER(cell) You get TRUE or FALSE? Gord Dibben MS Excel MVP On Tue, 10 Mar 2009 13:37:15 -0400, "Robert11" wrote: Hi, Sorry for all these dumb questions, but I never had any problems with Excel 97. This one is apparently just too complicated for me at my old age. Anyway, thanks for all the help; really appreciate it. So, using Excel 2007, and XP I select a cell that has a number in it with 5 decimal places. I go to Format Cells, and select Number, and tell it to go to 4 decimal places. It won't, and continues to show 5 decimal places. This is also true if I try it on a column of numbers. What am I not doing right ? (I am sure that what appears in the cell is truly a number, and not text.) Thanks, Bob |
#3
|
|||
|
|||
Format Cell Problem
There is one way to test
If your number is in A1 then enter this in B1 =ISNUMBER(A1) If you get FALSE then A1 does NOT contain a number hence the problem... Check for a ' in the cell (in EDIT mode - press F2 to get into edit mode) or extra space before/after the number... in Excel 2007 in the HOME ribbon there is a dropdown which shows the current formatting.. You will also see a button (they were there in 2003 too) with -0.00 Click on it to reduce the no. of digits after the decimal... Failing everything send the file to me... "Robert11" wrote: Hi, Sorry for all these dumb questions, but I never had any problems with Excel 97. This one is apparently just too complicated for me at my old age. Anyway, thanks for all the help; really appreciate it. So, using Excel 2007, and XP I select a cell that has a number in it with 5 decimal places. I go to Format Cells, and select Number, and tell it to go to 4 decimal places. It won't, and continues to show 5 decimal places. This is also true if I try it on a column of numbers. What am I not doing right ? (I am sure that what appears in the cell is truly a number, and not text.) Thanks, Bob |
#4
|
|||
|
|||
From OP: Format Cell Problem
Hi,
Gosh, am I embarrassed. It was text after all. Sure is a lot to learn. Sorry. As always, much thanks, Bob ----------------- "Robert11" wrote in message ... Hi, Sorry for all these dumb questions, but I never had any problems with Excel 97. This one is apparently just too complicated for me at my old age. Anyway, thanks for all the help; really appreciate it. So, using Excel 2007, and XP I select a cell that has a number in it with 5 decimal places. I go to Format Cells, and select Number, and tell it to go to 4 decimal places. It won't, and continues to show 5 decimal places. This is also true if I try it on a column of numbers. What am I not doing right ? (I am sure that what appears in the cell is truly a number, and not text.) Thanks, Bob |
Thread Tools | |
Display Modes | |
|
|