View Single Post
Old 09-22-2019, 01:16 PM
RonDBD RonDBD is offline Windows 8 Office 2010 64bit
Join Date: Oct 2013
Posts: 24
RonDBD is on a distinguished road
Default mm:ss format problem

See attached. Col C contains song length in mm:ss: it imported from a pdf that way.
I copied C to D and set Format Cells to mm:ss: now numbers get interpreted as hh:mm, for display. Format as shown in data entry area is hh:mm:ss AM.
Puzzling. I can solve the problem by adding 0: to the front of each length, because I then have h:mm:ss.
Attached Files
File Type: xlsx List 1 - Copy.xlsx (10.8 KB, 5 views)
Reply With Quote