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

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

Center on colon
 

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

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