All Questions
3
questions
0
votes
0
answers
286
views
How to automatically use "From Text/CSV" when opening .csv file in Excel
When opening a CSV file in Excel the normal way it works ok, but the way it displays the data is lackluster. I recently discovered that under the "Data" tab there is a button "From Text/CSV". When you ...
1
vote
0
answers
3k
views
Excel Text Import Wizard Default Delimiter
Within the Text import Wizard, the default delimiter is TAB. Is it possible to permanently modify this default to be a comma?
Don't be tempted to think that this is a duplicate question. Neither this ...
1
vote
1
answer
89
views
Applying settings by default to CSV documents opened in MS Excel
End-users of a system we are developing are given a plain-old CSV file that end users will be opening in MS Excel. One of the columns will contain entries which consist of strings of numeric digits. ...