Format Painter Doesn't Work

parastichopis

New Member
Joined
Feb 17, 2018
Messages
2
(Using both the latest Excel release (2019?) and libraries with legacy releases) I have some music track time lengths that are in the format 5:43 (h:mm), but another column displays 5:43:00 AM. So I used both the Format, Number, Custom, h:mm option on the cells that showed the AM designation but it won't get rid of the AM. If I select the cell with the formatting I want, then selected the Format Painter, then apply it to the cell whose formatting I want to change to it either converts the time into a decimal out to 2 places, or it won't get rid of the AM.
 

Forum statistics

Threads
1,078,370
Messages
5,339,793
Members
399,325
Latest member
smilevenki

Some videos you may like

This Week's Hot Topics

Top