Re: Devil's advocate
You make some good points. Many of the posts here show frustration with MS for making the tool try to do your job for you when if it just left well alone we'd (or most of us) would be a lot happier.
A case in point is the use of the ' at the start of a value.
Great but... when you use that data after some manipulation in excel as input for another application is when the problems really start.
All many of is need is a way to stop Excel from making any assumptions on the data we are importing/using. Don't drop leading zero's, don't convert numbers to scientific notation (normal people don't understand that anyway) etc etc
If MS were to do that an awful lot of people here and in other forums would go away happy.
It is not too much to ask is it? It is our data after all or has MS laid claims to that now?