|
You must first be logged in to edit a post.
If you are not registered, please click "Create Account".
Excel Wizards... nevermind!
| Posted By |
Message |
Lucky09
2017!
Member since 1/06 7539 total posts
Name:
DW
|
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.
|
Posted 5/10/08 4:41 PM  |
| |
|
Potentially Related Topics:
Currently 624578 users on the LIFamilies.com Chat
|
