Thanks, Rick!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rick Rothstein (MVP - VB)" wrote in message ...
| <"hh:mm:ss "/mile"
|
| That should have been hh:mm:ss "/mile" between quotes. Don't
| enter the outer quotes in the Type box. I hope you're still following.
|
| You can also do it without the quote marks as long as you use backslashes in
| front of the format's meta-characters.
|
| hh:mm:ss /\mil\e
|
| Rick
|