Excel Wizards... nevermind!

If a number is entered as text format as 2356

how would I write a formula to change it to 23:56

Basically I need a formula to insert a ":" after the first two numbers.

I can't just format the cells into time. It won't let me

THANK YOU!

nevermind! I just figured it out!

=LEFT(D4,2)&":"&RIGHT(D4,2)

I feel like a genius.

Message edited 5/10/2008 4:46:20 PM.