Anyone have ADVANCED Excel skills?

[meriruka]

This might sound silly, but is your number lock off?
If not, you may have better luck emailing the whole spreadsheet to one of us..........

 

[debilorrah]

It's not a wrong formula, but the rescrambled is supposed to stay til I hit F9 again, and it rescrambles with every entry, which is a problem because I have other information to add next to each cell everytime I rescramble it. I have been cutting and pasting the result in another wortksheet cuz it's makin me crazy.

 

[meriruka]

Is this a macro with F9 as the "trigger" button?

 

[debilorrah]

F9 recalulates cells with formula's in it no matter what kind.. like I have the footer with the file name and 12 months in a spreadsheet, and Oct says Sept and I hit F9 it updates the cells.

 

[skirbo]

Then maybe take a look at the basic stuff you might not think to check, like the cell formats, etc. Someone else might have accidentally changed a setting.