Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to view how a cell is currently formatted?
I am gettin the #VALUE! error in one of my formulas and one of the possble
reasons is that numbers may be formatted as text. The workbook I am working in is protected so I cannot chang the formatting of the cells. I just need to see if that is the problem so I can see what action needs to be taken. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to view how a cell is currently formatted?
You can see it from another workbook. Use a formula (in a second workbook)
like =[Book1]Sheet1!$C$1 If that formula is in A1, use =ISNUMBER(A1) in another cell. -- Kind regards, Niek Otten Microsoft MVP - Excel "Andreawilson5" wrote in message ... I am gettin the #VALUE! error in one of my formulas and one of the possble reasons is that numbers may be formatted as text. The workbook I am working in is protected so I cannot chang the formatting of the cells. I just need to see if that is the problem so I can see what action needs to be taken. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to view how a cell is currently formatted?
Numbers align right and text aligns left in worksheet cells. If you have a number on the left side of a cell and the toolbar alignment button is not activated then the number is probably being treated as text. -- Jim Cone Portland, Oregon USA "Andreawilson5" wrote in message I am gettin the #VALUE! error in one of my formulas and one of the possble reasons is that numbers may be formatted as text. The workbook I am working in is protected so I cannot chang the formatting of the cells. I just need to see if that is the problem so I can see what action needs to be taken. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do I get this ###### instead of 11:00 p.m. in formatted cell? | New Users to Excel | |||
Formatted Cell | Excel Discussion (Misc queries) | |||
Can't view formatted cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Why can't I see my entire formatted merged cell in print view eve. | Excel Discussion (Misc queries) | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions |