formula remian in cell

D

Dylan @ UAFC

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

waht can i do
 
M

Mike H

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Cell data entering slow! 0
Merging from an Excel file with graphics 1
Table Header Cells keep shifting 8
Icon doesn't make sense 0
Converting a number into a cell reference 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8

Top