I have a formula in a cell on sheet1 =TODAY()-1 &" 7:00 AM" that I cannot seem to get the format correctly. The cell is formatted time 02/10/2015 7:00 AM but the formula keeps bring back serial number...42045 7:00 AM. Excel 2013 and the workbook is saved as .xlsx. Any help is appreciated...driving me nuts!
Deleted, for being incorrect formula.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
How about:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
That did it...thanks you!Originally Posted by ConneXionLost
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks