Try CTRL+ALT+F9, this will force Excel to re-calc all cells.On 2002-04-05 04:52, aaron_brown99 wrote:
I've seen this issue on the board, but the answers so far aren't working for me.
I have a spreadsheet which lists times in minutes and seconds measuring the time an agent is on a call with a customer. The file was output in excel format, but the time field is formatted as general.
When I change the format to mm:ss AND RECALCULATE THE SHEET, the values don't change to the correct format. If I apply a SUM function, it reads as 00:00. Only by double-clicking each cell can I get the value to actually switch format and work in calculations.
I MUST be doing something wrong, I hope. Can anyone advise me?
Does this work for you?
Regards,
Like this thread? Share it with others