Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going nuts in Excel 2003
Hi guys & gals,
I must have a button pushed or something that I don't know about. I'm entering =IF($L5="","",$C5). That's exactly what it shows in the cell. It's as if I have it preceded with a ', but I don't. I set the format to general,,,still no good. Other cols it won't let me change the format. These are brand new worksheets so I don't know what the problem is. Is it the num lock or insert key?? thanks for any help. -- Rich D Armstrong Custom Homes Redmond |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going nuts in Excel 2003
Try
CTRL+` The ` is to the left of the 1 key Mike "Rich D" wrote: Hi guys & gals, I must have a button pushed or something that I don't know about. I'm entering =IF($L5="","",$C5). That's exactly what it shows in the cell. It's as if I have it preceded with a ', but I don't. I set the format to general,,,still no good. Other cols it won't let me change the format. These are brand new worksheets so I don't know what the problem is. Is it the num lock or insert key?? thanks for any help. -- Rich D Armstrong Custom Homes Redmond |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going nuts in Excel 2003
that enables me to see all my formulas or not, but it didn't solve the
problem. There is something messed up in that it won't allow me to change formats in cells either. -- Rich D Armstrong Custom Homes Redmond "Mike H" wrote: Try CTRL+` The ` is to the left of the 1 key Mike "Rich D" wrote: Hi guys & gals, I must have a button pushed or something that I don't know about. I'm entering =IF($L5="","",$C5). That's exactly what it shows in the cell. It's as if I have it preceded with a ', but I don't. I set the format to general,,,still no good. Other cols it won't let me change the format. These are brand new worksheets so I don't know what the problem is. Is it the num lock or insert key?? thanks for any help. -- Rich D Armstrong Custom Homes Redmond |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going nuts in Excel 2003
Rich
Make sure the cell is not formated to text BEFORE you enter your formula. If the cell is formated to text and the formula is in place delete the formulaformate as GENERAL re-enter the formula and it should work. There are also other ways to do the same thing but this works. Mike Rogers "Rich D" wrote: Hi guys & gals, I must have a button pushed or something that I don't know about. I'm entering =IF($L5="","",$C5). That's exactly what it shows in the cell. It's as if I have it preceded with a ', but I don't. I set the format to general,,,still no good. Other cols it won't let me change the format. These are brand new worksheets so I don't know what the problem is. Is it the num lock or insert key?? thanks for any help. -- Rich D Armstrong Custom Homes Redmond |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going nuts in Excel 2003
Once the formula is entered as Text, changing cell number format has no
effect, since XL interprets it as as text string. Format the cell as General, then reenter the formula. In article , Rich D wrote: that enables me to see all my formulas or not, but it didn't solve the problem. There is something messed up in that it won't allow me to change formats in cells either. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going nuts in Excel 2003
I think your second problem is the key:
....it won't let me change the format in other columns... Both problems could be explained if you had extra spaces, CHAR(0160) in your cells. Find/Replace ALT+0160 in all cells. Type the number from the keypad. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going nuts in Excel 2003
Rather than deleting and re-entering the formula, just hit F2 then ENTER key
after formatting to General. Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 08:22:03 -0800, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom wrote: Rich Make sure the cell is not formated to text BEFORE you enter your formula. If the cell is formated to text and the formula is in place delete the formulaformate as GENERAL re-enter the formula and it should work. There are also other ways to do the same thing but this works. Mike Rogers "Rich D" wrote: Hi guys & gals, I must have a button pushed or something that I don't know about. I'm entering =IF($L5="","",$C5). That's exactly what it shows in the cell. It's as if I have it preceded with a ', but I don't. I set the format to general,,,still no good. Other cols it won't let me change the format. These are brand new worksheets so I don't know what the problem is. Is it the num lock or insert key?? thanks for any help. -- Rich D Armstrong Custom Homes Redmond |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going nuts in Excel 2003
Gord
I knew there was a key stroke to do it....just could't remember it <vbg Mike Rogers "Gord Dibben" wrote: Rather than deleting and re-entering the formula, just hit F2 then ENTER key after formatting to General. Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 08:22:03 -0800, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom wrote: Rich Make sure the cell is not formated to text BEFORE you enter your formula. If the cell is formated to text and the formula is in place delete the formulaformate as GENERAL re-enter the formula and it should work. There are also other ways to do the same thing but this works. Mike Rogers "Rich D" wrote: Hi guys & gals, I must have a button pushed or something that I don't know about. I'm entering =IF($L5="","",$C5). That's exactly what it shows in the cell. It's as if I have it preceded with a ', but I don't. I set the format to general,,,still no good. Other cols it won't let me change the format. These are brand new worksheets so I don't know what the problem is. Is it the num lock or insert key?? thanks for any help. -- Rich D Armstrong Custom Homes Redmond |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Excel Has Gone Nuts! | Excel Discussion (Misc queries) | |||
My Boss is nuts | Excel Worksheet Functions | |||
Need Help, this is driving me nuts | Excel Discussion (Misc queries) | |||
question driving me nuts | New Users to Excel | |||
Excel / VB is driving me nuts!! | Excel Worksheet Functions |