View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] brotherescott@yahoo.com is offline
external usenet poster
 
Posts: 18
Default Custom Cell format to mimic time format

I am trying to make the custom cell format change the display of a
number like 3.20 to 3:20
I tried ?0":" for a cell format but I cant get the decimal part to
work. I basically want it to look like a time format but not be one. If
I use mm:ss then it totally changes 3.20 into 4:48 Some time conversion
is applied.

0.":"_.00 was close. It shows 3.:20

I would appreciate any help.

Thanks
Scott