LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default format numbers as mm:ss

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert numbers from text format to number format merlin68 Excel Discussion (Misc queries) 7 June 20th 07 07:03 PM
excel numbers in general format i cant add cant change format claude Excel Worksheet Functions 2 July 7th 06 08:18 PM
cell format: numbers won't be numbers Craig Fletcher Excel Discussion (Misc queries) 12 May 1st 06 11:04 PM
FORMAT NUMBERS IN CRORE FORMAT (##,##,##,###) R Shankar Excel Worksheet Functions 1 July 5th 05 03:01 PM
How do i change numbers in text format to number format? Greg New Users to Excel 1 December 14th 04 05:22 PM


All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"