ExcelBanter - formula remian in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula remian in cell (https://www.excelbanter.com/excel-worksheet-functions/217226-formula-remian-cell.html)

Dylan @ UAFC[_3_]

formula remian in cell

I have one column in work sheet were the formula shows in the
cell and will not go away

waht can i do

Mike H

formula remian in cell

Hi,

If it's a single column then it's a fair bet the cell was formatted as text
before the formula was entered. Re-format as 'general' with the cell selected
tap F2 and enter.

Mike

"Dylan @ UAFC" wrote:

I have one column in work sheet were the formula shows in the
cell and will not go away

waht can i do

Gord Dibben

formula remian in cell

If other columns' formulas are OK then I would suggest you have
pre-formatted the offending column as text.

Format to General then F2 and ENTER on each cell.

Gord Dibben MS Excel MVP

On Tue, 20 Jan 2009 12:49:01 -0800, Dylan @ UAFC
wrote:

I have one column in work sheet were the formula shows in the
cell and will not go away

waht can i do

All times are GMT +1. The time now is 12:20 AM.