How to avoid auto format changing in excelHow do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?Microsoft Excel mangles Diacritics in .csv files?How to concatenate text from multiple rows into a single text string in SQL server?How to output MySQL query results in CSV format?Excel changes date formatsHow to import CSV file to MySQL tableExcel to CSV with UTF8 encodingIs it possible to force Excel recognize UTF-8 CSV files automatically?How to avoid using Select in Excel VBAHow to avoid Python/Pandas creating an index in a saved csv?
Why use null function instead of == []
Is a public company able to check out who owns its shares in very detailed format?
Should you avoid redundant information after dialogue?
Do native speakers use ZVE or CPU?
Mistakenly modified `/bin/sh'
Why linear regression uses "vertical" distance to the best-fit-line, instead of actual distance?
Can a pizza stone be fixed after soap has been used to clean it?
HackerRank: Electronics Shop
Is `curl something | sudo bash -` a reasonably safe installation method?
Meaning of slash chord without anything left of the slash
Behavior of the zero and negative/sign flags on classic instruction sets
What are the arguments for California’s nonpartisan blanket primaries other than giving Democrats more power?
Why is "dark" an adverb in this sentence?
Old short story where the future emperor of the galaxy is taken for a tour around Earth
Why is the collector feedback bias popular in electret-mic preamp circuits?
Getting fresh water in the middle of hypersaline lake in the Bronze Age
Can a continent naturally split into two distant parts within a week?
Concatenation using + and += operator in Python
Remove intersect line for one circle using venndiagram2sets
Won 50K! Now what should I do with it
What exactly is the Tension force?
Is this more than a packing puzzle?
Will it hurt my career to work as a graphic designer in a startup for beauty and skin care?
How to make "plastic" sounding distored guitar
How to avoid auto format changing in excel
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?Microsoft Excel mangles Diacritics in .csv files?How to concatenate text from multiple rows into a single text string in SQL server?How to output MySQL query results in CSV format?Excel changes date formatsHow to import CSV file to MySQL tableExcel to CSV with UTF8 encodingIs it possible to force Excel recognize UTF-8 CSV files automatically?How to avoid using Select in Excel VBAHow to avoid Python/Pandas creating an index in a saved csv?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have a csv document which has a column in the format of "year-week" such as
enter image description here
when I try to open it with excel, it was automatically changed into the following format:
enter image description here
If I change the format to Text, it will be
enter image description here
How can I avoid this change?
Thanks
excel csv
asked Mar 26 at 6:35
HarukaHaruka
11 bronze badge
add a comment |
I have a csv document which has a column in the format of "year-week" such as
enter image description here
when I try to open it with excel, it was automatically changed into the following format:
enter image description here
If I change the format to Text, it will be
enter image description here
How can I avoid this change?
Thanks
excel csv
asked Mar 26 at 6:35
HarukaHaruka
11 bronze badge
1
Import the CSV properly with Data, Get external data, From text and specify that column as Text.
– user11246173
Mar 26 at 6:49
add a comment |
I have a csv document which has a column in the format of "year-week" such as
enter image description here
when I try to open it with excel, it was automatically changed into the following format:
enter image description here
If I change the format to Text, it will be
enter image description here
How can I avoid this change?
Thanks
excel csv
asked Mar 26 at 6:35
HarukaHaruka
11 bronze badge
I have a csv document which has a column in the format of "year-week" such as
enter image description here
when I try to open it with excel, it was automatically changed into the following format:
enter image description here
If I change the format to Text, it will be
enter image description here
How can I avoid this change?
Thanks
excel csv
excel csv
asked Mar 26 at 6:35
HarukaHaruka
11 bronze badge
asked Mar 26 at 6:35
HarukaHaruka
11 bronze badge
edited Mar 26 at 6:59
Haruka
asked Mar 26 at 6:35
HarukaHaruka
11 bronze badge
asked Mar 26 at 6:35
HarukaHaruka
11 bronze badge
asked Mar 26 at 6:35
HarukaHaruka
11 bronze badge
11 bronze badge
1
Import the CSV properly with Data, Get external data, From text and specify that column as Text.
– user11246173
Mar 26 at 6:49
add a comment |
1
Import the CSV properly with Data, Get external data, From text and specify that column as Text.
– user11246173
Mar 26 at 6:49
1
1
Import the CSV properly with Data, Get external data, From text and specify that column as Text.
– user11246173
Mar 26 at 6:49
Import the CSV properly with Data, Get external data, From text and specify that column as Text.
– user11246173
Mar 26 at 6:49
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55351103%2fhow-to-avoid-auto-format-changing-in-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55351103%2fhow-to-avoid-auto-format-changing-in-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Import the CSV properly with Data, Get external data, From text and specify that column as Text.
– user11246173
Mar 26 at 6:49