I have an excel spreadsheet with a time column that will not format. I want to combine the date and time columns. But the formula produces #VALUE!. I tried just formatting the time and it does not do it. Also, once you hide rows at the top, how do you unhide them?