|
|
#5
09-22-2019, 01:16 PM
|
|||
|
|||
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. 
|
| Tags |
| format cells |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2013 Messages can sit in the Outbox anywhere from 5 seconds up to 60 seconds | BNS1968 | Outlook | 0 | 09-16-2016 08:07 PM |
 Format a range of cells
|
Dave T | Excel Programming | 1 | 06-01-2016 08:58 PM |
|
Convert large seconds values to a time format fails with #Value
|
Sekerob | Excel | 3 | 07-18-2015 01:56 PM |
|
Procedure for displaying symbols for degrees, minutes, seconds
|
kinglaird | Excel | 1 | 01-17-2015 02:04 AM |
|
How-TO format cells (FILL) by comparing cells
|
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
Windows 8 
Office 2010 64bit
Threaded Mode