| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Center on colon
I have a table of times in the format "Time, 13:30" using Arial font. For
asthetics, I decided to center the time in the cells. This results in the colons being out of line. Is there a way to center the cell on the colon? Similar to the "decimal tab stop" in Word that aligns columns to the decimal point. Jason |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Center on colon
custom format as he:mm
-- Don Guillett Microsoft MVP Excel SalesAid Software "WJason" wrote in message ... I have a table of times in the format "Time, 13:30" using Arial font. For asthetics, I decided to center the time in the cells. This results in the colons being out of line. Is there a way to center the cell on the colon? Similar to the "decimal tab stop" in Word that aligns columns to the decimal point. Jason |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Center on colon
Thanks Don,
That works; but adds a 0 padding on the left. "Don Guillett" wrote: hH:mm -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... custom format as he:mm -- Don Guillett Microsoft MVP Excel SalesAid Software "WJason" wrote in message ... I have a table of times in the format "Time, 13:30" using Arial font. For asthetics, I decided to center the time in the cells. This results in the colons being out of line. Is there a way to center the cell on the colon? Similar to the "decimal tab stop" in Word that aligns columns to the decimal point. Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Semi Colon Deliminated File | Excel Discussion (Misc queries) | |||
| Add colon to times | New Users to Excel | |||
| Insert colon in text in cell | Excel Discussion (Misc queries) | |||
| Replace nth place with colon | Excel Worksheet Functions | |||
| Center Across Selection Vertically Help. I am trying to center te. | Excel Discussion (Misc queries) | |||
Linear Mode
