Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hey folks.
i have a list of tracks formatted in a table in Word - a simple column of track name, and then the length in mm:ss (example: 9:58 - 9 minutes, 58 seconds) I am copying into Excel. but Excel understands this as a time format - so it displays (and converts per the various cell formats) as : 9 hours, 58 minutes and 0 seconds. is there a way to rectify this? Thanks Muchly! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
cell format: numbers won't be numbers | Excel Discussion (Misc queries) | |||
FORMAT NUMBERS IN CRORE FORMAT (##,##,##,###) | Excel Worksheet Functions | |||
How do i change numbers in text format to number format? | New Users to Excel |