I'm generating CSV files from a script and then want to look at them with Excel. I noticed Excel does a smart job of identifying money (by the $) and dates, and formats those cells accordingly. However, with my percentage column it wasn't so smart as to remove the % from the values and yet render it as percentages (as it did with $). Also, I have columns where I want to format them to show a fixed number of decimals, and despite padding the values it discards them.
Is there a way I can give Excel more clues about these last two types so that it will format my data as I want? I don't want to use the Wizard or manually format each time.