|
| 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
February 4th, 2009, 09:08 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
cell value
I have a cell that will not accept a formula. I enter =B6 and the cell does
not return the value in B6 but returns the text =B6. This is the only cell in a multi sheet w Help wiorkbook that does this. What's going on? Help will be appreciated. Thanks, Gulfman 
|
|
#2
February 4th, 2009, 09:16 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
cell value
Hi
The cell is formatted as text, delete the cell then go and format as General. Retype your formula. HTH John "Gulfman100" wrote in message ... I have a cell that will not accept a formula. I enter =B6 and the cell does not return the value in B6 but returns the text =B6. This is the only cell in a multi sheet w Help wiorkbook that does this. What's going on? Help will be appreciated. Thanks, Gulfman
|
|
#3
February 4th, 2009, 09:17 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
cell value
On Wed, 4 Feb 2009 13:08:37 -0800, Gulfman100
wrote: I have a cell that will not accept a formula. I enter =B6 and the cell does not return the value in B6 but returns the text =B6. This is the only cell in a multi sheet w Help wiorkbook that does this. What's going on? Help will be appreciated. Thanks, Gulfman The cell is probably formatted as text. Change the cell format by right clicking on the cell and choose "Format Cells...". Then select Number General.and click OK. Finally reenter the =B6 in the cell. Hope this helps / Lars-Åke
|
|
#4
February 4th, 2009, 10:34 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
cell value
Rather than deleting and re-typing, change the format to General then F2,
Enter Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 16:16:02 -0500, "John" wrote: Hi The cell is formatted as text, delete the cell then go and format as General. Retype your formula. HTH John "Gulfman100" wrote in message ... I have a cell that will not accept a formula. I enter =B6 and the cell does not return the value in B6 but returns the text =B6. This is the only cell in a multi sheet w Help wiorkbook that does this. What's going on? Help will be appreciated. Thanks, Gulfman
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
