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?????

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

You can only wrap the text

VBA Noob

**caball1** · 03-08-2007, 04:05 PM

Thank You So Much For All Your Help

**VBA Noob** · 03-08-2007, 04:06 PM

Lol..sorry I couldn't help

VBA Noob

**caball1** · 03-08-2007, 04:28 PM

How can you view only the current page you are working with in excel without seeing all the other Pages..... you know how it looks like it is preforated???

**VBA Noob** · 03-08-2007, 04:32 PM

Are you refering to print preview.

Try changing to normal view

VBA Noob

**caball1** · 03-08-2007, 04:44 PM

I am in normal view however I see a new blank page to the right of the page i am currently working in and I see a new blank page below also, I just want to see the page I am working in????

**VBA Noob** · 03-08-2007, 04:46 PM

Can you post an image of your view

VBA Noob

**caball1** · 03-08-2007, 04:57 PM

OMG! For some reason it says the attachment failed.......I am getting to the point where I just want to take this computer in an empty field and beat it to pieces like in Office Space (the movie)......but I know it is the operator not the machine which causes it to act retarded....