I need some help, desperately. I was sent a spreadsheet with several
thousand entries, and all of the dates reported as (example) 1015. Is there
a function that I can go into the next column and say " take value in A1 and
move over two places, add a ":", in theory converting them to a proper format
for time. Any help would be greatly appreciated.