Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Format Cell | Excel Discussion (Misc queries) | |||
Reference Cell in custom format???? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |