I’ve got a quick Excel question I’m hoping someone may have the answer to.
I have reports which are generated by one program, saved in text format, and then opened with Excel. I have no problems getting the data into my spreadsheet, but some of the columns are formatted in ways which Excel isn’t recoginizing correctly for me. My problems are:
Dates. The report lists dates in the format MMDDYY or YYYYMMDD. For example today would be either 072507 or 20070705. Excel doesn’t seen this as the correct date for me.
Negative numbers. The report puts the minus sign after the number for some reason. Excel hasn’t been recognizing 100- as -100.
So far these reports haven’t been all that large, so I’ve gone back and made the corrections manually as needed. But, it is still kind of time consuming, and if the reports ever get longer it may become impossible.
Any quick way to make Excel recognize the information the way I want it to?
Thanks for the help.