Excel 2003 Formula Bar

[anorthcote]

Hi,

I have a strange query on Excel 2003 and the way it displays the formula bar.

If I put the following formula in a cell

+(3000/13)*4

I get the answer 923 in the cell. If I click back onto the cell what I would expect to see in the formula bar is =+(3000/13)*4. On a blank spreadsheet this is so but on a few spreadsheets I get the formula

=+(230.769230769231)*4

Excel seems to be putting the answer to the (3000/13) part of the equasion into the formula.

WHY??????

Please can someone tell me if this is an option in Excel and how to turn it off!!

Thanks

 

[xlhelp]

Are any of the boxes checked under Tools, Options, Transition? If so, uncheck them.

Member- AAAA Association Against Acronym Abusers

 

[anorthcote]

No.

I've checked all of the options and compared them to a blank spreadsheet that works in the expected way.

Thay are all the same.

 

[GlennUK]

It looks like someone has selected the 3000/13 part of the formula, pressed F9 and then Enter. Are you sure this is happening automatically?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[anorthcote]

This is definately happening automatically, I have tried it myself on the users spreadsheet.

It only seems to happen on certain cells, if I insert a cell then delete the original then the problem goes away. This makes me think that it is a cell format but I cannot find anything that would cause this.

The spreadsheet in question is very big and complex and has several cells with the same problem so deleteing and inserting cells isn't really a valid solution.

Can anyone help???

 

[GlennUK]

Unfortunately I don't have access to Excel 2003 today, to do any experiments. If I get time at lunch time I'll search the net to see if anyone else has reported this. I suppose the formula calculation engine could generate this kind of thing ... but have never seen it happen on old versions of Excel.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.