No. Remember we are dealing over a decade of "how it worked then and now." While you may disagree with how it works I read your post twice and see you know how to deal with this.
Was there something you needed fixing that your rename didn't fix?
Office 2003 and 2007 behave the same way. As I can recall all Office version behave the same way.
I have csv files with numbers that have a decimal place followed by a 0. When opening the csv file Excel strips off the decimal place and 0.
Shouldn't Excel treat this type of file as text and not auto-covert? I sure think so.
Also, if I format a worksheet as text, and fill a column with 0, select the column, perform a replace all 0 to 0.0 the result is 0 not 0.0. This is crap.
A macro that does this works.
I know the trick of renaming .csv to .txt, shouldn't Excel handle all text files the same?