Formulas are showing in cell instead of the result of the formula...

**caball1** · 03-08-2007, 02:00 PM

I tried doing Ctrl + ~, but it did not work......HELP PLEASE

**VBA Noob** · 03-08-2007, 02:01 PM

Hi,

Try changing the cell format to general

VBA Noob

**caball1** · 03-08-2007, 02:08 PM

No dice!!!

**VBA Noob** · 03-08-2007, 02:11 PM

How about

Tools > options > view tab and make sure formulas is unticked.

or see if you have a leading space before your formulas

or if you have a ' in front of formulas

VBA Noob

**caball1** · 03-08-2007, 02:20 PM

I am telling you it is! RETARDED...Got anything else

**VBA Noob** · 03-08-2007, 02:21 PM

Can you post the file

Have you manually tried to retype a formula

Is Tools > Options > Calculation tab > auto calc on

VBA Noob

**caball1** · 03-08-2007, 03:58 PM

I just started a new workbook..... it works now! However I was wondering how do you change the width of an individual cell without changing the width of the entire row?????