I have 7522 cells that have numbers in them. They're SUPPOSED to be times. I was asked if these cells (part of a larger worksheet) could be converted into times. I've been screwing with it for several hours, trying to come up with a formula, but so far nothing works the way I need it to.
I need "2200" to read as "22:00", "300" to read as "3:00", "1500" to read as "15:00" etc.
How can this be done?
I need "2200" to read as "22:00", "300" to read as "3:00", "1500" to read as "15:00" etc.
How can this be done?