| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
