EXCEL Column Formatting issue

It would appear that since this is normally a date format that the program is assisting you with getting it in the correct format for you. Nice of Uncle Bill to help you like that, isn't it?
Looks like there are only a couple of things you can do.
1)put a single quote in front of the account number. (ex> '5140-11-30 )This tells excel to just read what's after the quote.

2) You could change the format of the account number to use another character like a period or underscore.

Sorry I don't have a better answer.
Hope this helps.

I assume you are saving to CSV for import into some other program? You can look at the csv file in notepad and probably you'll see that the records come out properly if they looked right in Excel prior to saving in csv format.

The problem is that you are most likely then trying to load the csv file back into excel, and it has no idea how you formatted them before... it does the same thing it would do if you type that value in, and assumes it is a date until you tell it otherwise.

The single quote technique will work only as long as you save to an excel format such as .xls if you need the .csv for another application, then save it in BOTH formats....