formula disappears

Brian from Maui

MrExcel MVP

Joined

Feb 16, 2002

Messages

8,459

• Dec 23, 2004

• #2

Craig92604 said:

My computer crashed at work and they gave me another piece of junk

In certain cells when I enter simple formulas like +256/20000 I get the correct calculation in the cell but the formula goes away. I'm sure it is some setting in option but can't figure it out

Click to expand...

If you check the formula bar, the formula should still be there

 

Upvote 0

C

Craig92604

Well-known Member

Joined

Nov 7, 2002

Messages

505

• Dec 23, 2004

• #3

I know it should be but instead of the formula being there it shows the results?

 

Upvote 0

Y

Yogi Anand

MrExcel MVP

Joined

Mar 12, 2002

Messages

11,454

• Dec 23, 2004

• #4

Hi Craig:

You said it happens in some cells -- so that means not in every cell. It sure is strange -- what version of EXCEL is installed on your new computer?

Couple of things to look at ...

1) is there a macro running in the background?

2) is your worksheet protected?

3) are the cells in question formatted as Hidden/Locked?

 

Upvote 0

C

Craig92604

Well-known Member

Joined

Nov 7, 2002

Messages

505

• Dec 23, 2004

• #5

1. I can't find any macros

2. Worksheet is not protected

3. Cells in question are not hidden or locked

Version 2000 (9.0.2720) Computer is about 4 years old
Very strange infact on the same sheet in a different cell I don't have the problem

 

Upvote 0