![]() |
|
#12
|
|||
|
|||
|
FormatCells>Custom: Into Type field enter the format.
You can also use formats like "[h]:mm:ss" or "[s]", but not "[d]" or "[d] hh:mm:ss". The feature is available at least from year 2000, when I started to use MS Office instead of Quattro Pro and Visual FoxPro. But I'm not sure about web-based Office! I have MS Office installed in my computer. |
| 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 |