reaktorblue
Board Regular
- Joined
- Aug 8, 2007
- Messages
- 87
- Office Version
- 365
- Platform
- Windows
I have a macro that runs to clean up a report however, the values in the report are time and formatted with [hh]:mm:ss. The problem I run into is Excel does not seem to format this correctly until you click into the formula bar and press enter. When this is completed, it formats the value correctly and then I can do the proper calculations.
Is there a way to make this an automated function?
Is there a way to make this an automated function?