I'm looking to remove only the trailing zero's from times in excel. i.e. 0700 should display as 07, but 1630 should remain as 1630.
I've been able to do this within a UDF, but it's starting to slow my sheet down. Is there any way of achieving this as an in-built function?