Saving to CSV changes data from numbers to written dates Announcing the arrival of Valued...
A journey... into the MIND
Why did Israel vote against lifting the American embargo on Cuba?
Coin Game with infinite paradox
"Destructive force" carried by a B-52?
Who's this lady in the war room?
Providing direct feedback to a product salesperson
Does traveling In The United States require a passport or can I use my green card if not a US citizen?
How to produce a PS1 prompt in bash or ksh93 similar to tcsh
Why doesn't the university give past final exams' answers?
“Since the train was delayed for more than an hour, passengers were given a full refund.” – Why is there no article before “passengers”?
When speaking, how do you change your mind mid-sentence?
Why isn't everyone flabbergasted about Bran's "gift"?
Can the van der Waals coefficients be negative in the van der Waals equation for real gases?
Can gravitational waves pass through a black hole?
Why do people think Winterfell crypts is the safest place for women, children & old people?
How do I deal with an erroneously large refund?
What is the definining line between a helicopter and a drone a person can ride in?
/bin/ls sorts differently than just ls
How to create a command for the "strange m" symbol in latex?
How to keep bees out of canned beverages?
Can I ask an author to send me his ebook?
Is it OK if I do not take the receipt in Germany?
What's the connection between Mr. Nancy and fried chicken?
Like totally amazing interchangeable sister outfit accessory swapping or whatever
Saving to CSV changes data from numbers to written dates
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Read data from separate CSV file in OpenOffice CalcHow to add time duration column total from Skype Call History CSV file in Excel 2010?Importing multiline cells from csv file into excelexcel truncating phone numberAutomatically format cells as currency from .CSV when importing into ExcelCSV stopping excel from changing column valuesDo blank rows at the end of CSVs cause issues?How do I copy specific selected data between cells in a CSV file in Excel or Notepad++?Saving Excel .csv on mac deletes and saves all rows except lastHow to use values from imported CSV in Excel formulas?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I Have an Excel file that contains data that change specific cells to a written date when saved as a CSV file....And I dont want that!
For instance "4000-03" in a cell will be "mars-00"
conditions:
1. Its not possible to add prefix or suffix because of # character limits in the cells
2. I need the file as an Excel CSV due to import rules. No other files will work.
3. It's not possible to post-process the cells.
Thanks/Christer
microsoft-excel-2013 csv
asked 6 hours ago
Christer JegbertChrister Jegbert
63
New contributor
Christer Jegbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I Have an Excel file that contains data that change specific cells to a written date when saved as a CSV file....And I dont want that!
For instance "4000-03" in a cell will be "mars-00"
conditions:
1. Its not possible to add prefix or suffix because of # character limits in the cells
2. I need the file as an Excel CSV due to import rules. No other files will work.
3. It's not possible to post-process the cells.
Thanks/Christer
microsoft-excel-2013 csv
asked 6 hours ago
Christer JegbertChrister Jegbert
63
New contributor
Christer Jegbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Is there a question in there?
– DBADon
6 hours ago
Sry Updated :) @DBADon
– Christer Jegbert
5 hours ago
1
It looks like in your locale, 4000-03 is a legitimate way to write March 4000, so Excel is interpreting it as a date. Typically, when creating a CSV, the problem is the other way around (values formatted as a date get stored as the internal date number). I'll need more coffee to think about an actual solution, but I can offer a workaround. Build the CSV records in the spreadsheet by concatenating the component cells (one record per row). That gives you control over how each value gets stored. Then export that column to a CSV file. (cont'd)
– fixer1234
4 hours ago
1
If the records would exceed cell character limits, just concatenate the problem cell with an adjacent cell and use that helper cell instead of the two columns when selecting what to export as CSV. That lets you control how it is stored, and once that problem number is part of a character string, Excel won't try to reinterpret it.
– fixer1234
4 hours ago
1
Is it possible toFormat > Cellsand change the column type toText?
– David Lord
2 hours ago
add a comment |
I Have an Excel file that contains data that change specific cells to a written date when saved as a CSV file....And I dont want that!
For instance "4000-03" in a cell will be "mars-00"
conditions:
1. Its not possible to add prefix or suffix because of # character limits in the cells
2. I need the file as an Excel CSV due to import rules. No other files will work.
3. It's not possible to post-process the cells.
Thanks/Christer
microsoft-excel-2013 csv
asked 6 hours ago
Christer JegbertChrister Jegbert
63
New contributor
Christer Jegbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I Have an Excel file that contains data that change specific cells to a written date when saved as a CSV file....And I dont want that!
For instance "4000-03" in a cell will be "mars-00"
conditions:
1. Its not possible to add prefix or suffix because of # character limits in the cells
2. I need the file as an Excel CSV due to import rules. No other files will work.
3. It's not possible to post-process the cells.
Thanks/Christer
microsoft-excel-2013 csv
microsoft-excel-2013 csv
asked 6 hours ago
Christer JegbertChrister Jegbert
63
New contributor
Christer Jegbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
Christer JegbertChrister Jegbert
63
New contributor
Christer Jegbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
Christer Jegbert
asked 6 hours ago
Christer JegbertChrister Jegbert
63
New contributor
Christer Jegbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
Christer JegbertChrister Jegbert
63
asked 6 hours ago
Christer JegbertChrister Jegbert
63
63
New contributor
Christer Jegbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Christer Jegbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Christer Jegbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Is there a question in there?
– DBADon
6 hours ago
Sry Updated :) @DBADon
– Christer Jegbert
5 hours ago
1
It looks like in your locale, 4000-03 is a legitimate way to write March 4000, so Excel is interpreting it as a date. Typically, when creating a CSV, the problem is the other way around (values formatted as a date get stored as the internal date number). I'll need more coffee to think about an actual solution, but I can offer a workaround. Build the CSV records in the spreadsheet by concatenating the component cells (one record per row). That gives you control over how each value gets stored. Then export that column to a CSV file. (cont'd)
– fixer1234
4 hours ago
1
If the records would exceed cell character limits, just concatenate the problem cell with an adjacent cell and use that helper cell instead of the two columns when selecting what to export as CSV. That lets you control how it is stored, and once that problem number is part of a character string, Excel won't try to reinterpret it.
– fixer1234
4 hours ago
1
Is it possible toFormat > Cellsand change the column type toText?
– David Lord
2 hours ago
add a comment |
1
Is there a question in there?
– DBADon
6 hours ago
Sry Updated :) @DBADon
– Christer Jegbert
5 hours ago
1
It looks like in your locale, 4000-03 is a legitimate way to write March 4000, so Excel is interpreting it as a date. Typically, when creating a CSV, the problem is the other way around (values formatted as a date get stored as the internal date number). I'll need more coffee to think about an actual solution, but I can offer a workaround. Build the CSV records in the spreadsheet by concatenating the component cells (one record per row). That gives you control over how each value gets stored. Then export that column to a CSV file. (cont'd)
– fixer1234
4 hours ago
1
If the records would exceed cell character limits, just concatenate the problem cell with an adjacent cell and use that helper cell instead of the two columns when selecting what to export as CSV. That lets you control how it is stored, and once that problem number is part of a character string, Excel won't try to reinterpret it.
– fixer1234
4 hours ago
1
Is it possible toFormat > Cellsand change the column type toText?
– David Lord
2 hours ago
1
1
Is there a question in there?
– DBADon
6 hours ago
Is there a question in there?
– DBADon
6 hours ago
Sry Updated :) @DBADon
– Christer Jegbert
5 hours ago
Sry Updated :) @DBADon
– Christer Jegbert
5 hours ago
1
1
It looks like in your locale, 4000-03 is a legitimate way to write March 4000, so Excel is interpreting it as a date. Typically, when creating a CSV, the problem is the other way around (values formatted as a date get stored as the internal date number). I'll need more coffee to think about an actual solution, but I can offer a workaround. Build the CSV records in the spreadsheet by concatenating the component cells (one record per row). That gives you control over how each value gets stored. Then export that column to a CSV file. (cont'd)
– fixer1234
4 hours ago
It looks like in your locale, 4000-03 is a legitimate way to write March 4000, so Excel is interpreting it as a date. Typically, when creating a CSV, the problem is the other way around (values formatted as a date get stored as the internal date number). I'll need more coffee to think about an actual solution, but I can offer a workaround. Build the CSV records in the spreadsheet by concatenating the component cells (one record per row). That gives you control over how each value gets stored. Then export that column to a CSV file. (cont'd)
– fixer1234
4 hours ago
1
1
If the records would exceed cell character limits, just concatenate the problem cell with an adjacent cell and use that helper cell instead of the two columns when selecting what to export as CSV. That lets you control how it is stored, and once that problem number is part of a character string, Excel won't try to reinterpret it.
– fixer1234
4 hours ago
If the records would exceed cell character limits, just concatenate the problem cell with an adjacent cell and use that helper cell instead of the two columns when selecting what to export as CSV. That lets you control how it is stored, and once that problem number is part of a character string, Excel won't try to reinterpret it.
– fixer1234
4 hours ago
1
1
Is it possible to
Format > Cells and change the column type to Text?– David Lord
2 hours ago
Is it possible to
Format > Cells and change the column type to Text?– David Lord
2 hours ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
Christer Jegbert is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1428380%2fsaving-to-csv-changes-data-from-numbers-to-written-dates%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
Christer Jegbert is a new contributor. Be nice, and check out our Code of Conduct.
Christer Jegbert is a new contributor. Be nice, and check out our Code of Conduct.
Christer Jegbert is a new contributor. Be nice, and check out our Code of Conduct.
Christer Jegbert is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1428380%2fsaving-to-csv-changes-data-from-numbers-to-written-dates%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
Is there a question in there?
– DBADon
6 hours ago
Sry Updated :) @DBADon
– Christer Jegbert
5 hours ago
1
It looks like in your locale, 4000-03 is a legitimate way to write March 4000, so Excel is interpreting it as a date. Typically, when creating a CSV, the problem is the other way around (values formatted as a date get stored as the internal date number). I'll need more coffee to think about an actual solution, but I can offer a workaround. Build the CSV records in the spreadsheet by concatenating the component cells (one record per row). That gives you control over how each value gets stored. Then export that column to a CSV file. (cont'd)
– fixer1234
4 hours ago
1
If the records would exceed cell character limits, just concatenate the problem cell with an adjacent cell and use that helper cell instead of the two columns when selecting what to export as CSV. That lets you control how it is stored, and once that problem number is part of a character string, Excel won't try to reinterpret it.
– fixer1234
4 hours ago
1
Is it possible to
Format > Cellsand change the column type toText?– David Lord
2 hours ago