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!

format numbers as mm:ss
 

In an empty cell enter 60 and copy it then highlight the cell with the time
and Paste Special Divide and re-format the cell as hh:mm:ss

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"moishie" wrote in message
...
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!

format numbers as mm:ss
 

amazing!!
both a speedy and accurate reponse!
thanks!

"Sandy Mann" wrote:

In an empty cell enter 60 and copy it then highlight the cell with the time
and Paste Special Divide and re-format the cell as hh:mm:ss

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"moishie" wrote in message
...
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!

format numbers as mm:ss
 

You're welcome - just passing on what I've learned here

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"moishie" wrote in message
...
amazing!!
both a speedy and accurate reponse!
thanks!

"Sandy Mann" wrote:

In an empty cell enter 60 and copy it then highlight the cell with the
time
and Paste Special Divide and re-format the cell as hh:mm:ss

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"moishie" wrote in message
...
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!