adding a colon to military time
Just as long as you are aware that this is not a real time.
Gord Dibben MS Excel MVP
On Thu, 6 Dec 2007 14:43:02 -0800, Suzanne
wrote:
This worked!!!! THANK YOU!!!!!
"CLR" wrote:
Try Custom format 00":"00
Vaya con Dios,
Chuck, CABGx3
"Suzanne" wrote:
I need to add a colon to military time. I need to change it from 1700 to
17:00. I want it to stay in military time. I don't want am or pm to show.
I can't figure out how to do this on the worksheet. Anyone know how to do
this?
|