Good morning,
I have one that's tricking me up a bit. I have some data that is presented in a date code of 201201012354 or (Jan. 1, 2012 at 23:54) and I'm trying to convert the string of numbers to a 01/01/2012 23:54 format but my =text formula has not been working. Anyone have any suggestions that might work.
201201010354 I want to equal 01/01/2012 03:54
201201010454 " " 01/01/2012 04:54
I've tried using =Text(B1,"0000-00-00-00:00")+0 but that has returned the "Value" error.
Thanks for any help you can provide.
Bookmarks