Entering Formula Changes Cell Format

[singincpa]

Hi all,

This is probably a basic problem, but I've never run across it in all my years of using Excel. I'm having an issue where the number format on my cells is changing when I enter a formula. It's set for accounting format and changes to fraction format. It doesn't happen all the time, so I don't know what's causing it.

Any assistance would be appreciated.

 

[Alex Blakenburg]

Is that by any chance the same worbook that contains the Worksheet event that you posted about here ?
Convert Worksheet Name to Date in a Cell