Formatting date in excel for csv upload
I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy.
Is there a way to save my mm/dd/yy format in csv file. Can I convert it to a text and save it as a csv?
microsoft-excel csv text-formatting
edited Sep 8 '18 at 9:36
phuclv
8,96063889
asked Aug 23 '14 at 18:48
john french
1113
add a comment |
I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy.
Is there a way to save my mm/dd/yy format in csv file. Can I convert it to a text and save it as a csv?
microsoft-excel csv text-formatting
edited Sep 8 '18 at 9:36
phuclv
8,96063889
asked Aug 23 '14 at 18:48
john french
1113
3
First, CSV is text. Second, now that you know that, open the CSV in notepad and paste a line here (replace any identifiable info first)
– krowe
Aug 24 '14 at 2:32
add a comment |
I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy.
Is there a way to save my mm/dd/yy format in csv file. Can I convert it to a text and save it as a csv?
microsoft-excel csv text-formatting
edited Sep 8 '18 at 9:36
phuclv
8,96063889
asked Aug 23 '14 at 18:48
john french
1113
I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy.
Is there a way to save my mm/dd/yy format in csv file. Can I convert it to a text and save it as a csv?
microsoft-excel csv text-formatting
microsoft-excel csv text-formatting
edited Sep 8 '18 at 9:36
phuclv
8,96063889
asked Aug 23 '14 at 18:48
john french
1113
edited Sep 8 '18 at 9:36
phuclv
8,96063889
asked Aug 23 '14 at 18:48
john french
1113
edited Sep 8 '18 at 9:36
phuclv
8,96063889
edited Sep 8 '18 at 9:36
phuclv
8,96063889
edited Sep 8 '18 at 9:36
phuclv
8,96063889
8,96063889
asked Aug 23 '14 at 18:48
john french
1113
asked Aug 23 '14 at 18:48
john french
1113
asked Aug 23 '14 at 18:48
john french
1113
1113
3
First, CSV is text. Second, now that you know that, open the CSV in notepad and paste a line here (replace any identifiable info first)
– krowe
Aug 24 '14 at 2:32
add a comment |
3
First, CSV is text. Second, now that you know that, open the CSV in notepad and paste a line here (replace any identifiable info first)
– krowe
Aug 24 '14 at 2:32
3
3
First, CSV is text. Second, now that you know that, open the CSV in notepad and paste a line here (replace any identifiable info first)
– krowe
Aug 24 '14 at 2:32
First, CSV is text. Second, now that you know that, open the CSV in notepad and paste a line here (replace any identifiable info first)
– krowe
Aug 24 '14 at 2:32
add a comment |
2 Answers
2
active
oldest
votes
There is a really good chance you're trying to solve something that isn't even a problem. Just do the import and see if it works.
Your question could use some more detail, but here is a key piece of information: Excel and Google Spreadsheets both treat dates as regular numbers (number of days since Jan 1, 1900). Whether you see a date as 8/25/14 or 8/25/2014 or 2014-08-25 or 25 August 2014 or 41876 is simply a display issue, and does not affect the data itself.
You can type 41876 into either Excel or Google Spreadsheets and then format it as a date to get 8/25/2014.
answered Aug 25 '14 at 21:45
Dane
1,6021117
add a comment |
Yes there is:
=TEXT(A1,"mm/dd/yy")
Alternatively, you can custom format the actual date cell (A1 in the formula above) by right clicking → Format Cells → Custom and entering the same format (mm/dd/yy).
edited Sep 8 '18 at 9:37
phuclv
8,96063889
answered Aug 25 '14 at 21:27
Scott Harris
1263
add a comment |
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
});
}
});
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%2f802089%2fformatting-date-in-excel-for-csv-upload%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
There is a really good chance you're trying to solve something that isn't even a problem. Just do the import and see if it works.
Your question could use some more detail, but here is a key piece of information: Excel and Google Spreadsheets both treat dates as regular numbers (number of days since Jan 1, 1900). Whether you see a date as 8/25/14 or 8/25/2014 or 2014-08-25 or 25 August 2014 or 41876 is simply a display issue, and does not affect the data itself.
You can type 41876 into either Excel or Google Spreadsheets and then format it as a date to get 8/25/2014.
answered Aug 25 '14 at 21:45
Dane
1,6021117
add a comment |
There is a really good chance you're trying to solve something that isn't even a problem. Just do the import and see if it works.
Your question could use some more detail, but here is a key piece of information: Excel and Google Spreadsheets both treat dates as regular numbers (number of days since Jan 1, 1900). Whether you see a date as 8/25/14 or 8/25/2014 or 2014-08-25 or 25 August 2014 or 41876 is simply a display issue, and does not affect the data itself.
You can type 41876 into either Excel or Google Spreadsheets and then format it as a date to get 8/25/2014.
answered Aug 25 '14 at 21:45
Dane
1,6021117
add a comment |
There is a really good chance you're trying to solve something that isn't even a problem. Just do the import and see if it works.
Your question could use some more detail, but here is a key piece of information: Excel and Google Spreadsheets both treat dates as regular numbers (number of days since Jan 1, 1900). Whether you see a date as 8/25/14 or 8/25/2014 or 2014-08-25 or 25 August 2014 or 41876 is simply a display issue, and does not affect the data itself.
You can type 41876 into either Excel or Google Spreadsheets and then format it as a date to get 8/25/2014.
answered Aug 25 '14 at 21:45
Dane
1,6021117
There is a really good chance you're trying to solve something that isn't even a problem. Just do the import and see if it works.
Your question could use some more detail, but here is a key piece of information: Excel and Google Spreadsheets both treat dates as regular numbers (number of days since Jan 1, 1900). Whether you see a date as 8/25/14 or 8/25/2014 or 2014-08-25 or 25 August 2014 or 41876 is simply a display issue, and does not affect the data itself.
You can type 41876 into either Excel or Google Spreadsheets and then format it as a date to get 8/25/2014.
answered Aug 25 '14 at 21:45
Dane
1,6021117
answered Aug 25 '14 at 21:45
Dane
1,6021117
answered Aug 25 '14 at 21:45
Dane
1,6021117
answered Aug 25 '14 at 21:45
Dane
1,6021117
1,6021117
add a comment |
add a comment |
Yes there is:
=TEXT(A1,"mm/dd/yy")
Alternatively, you can custom format the actual date cell (A1 in the formula above) by right clicking → Format Cells → Custom and entering the same format (mm/dd/yy).
edited Sep 8 '18 at 9:37
phuclv
8,96063889
answered Aug 25 '14 at 21:27
Scott Harris
1263
add a comment |
Yes there is:
=TEXT(A1,"mm/dd/yy")
Alternatively, you can custom format the actual date cell (A1 in the formula above) by right clicking → Format Cells → Custom and entering the same format (mm/dd/yy).
edited Sep 8 '18 at 9:37
phuclv
8,96063889
answered Aug 25 '14 at 21:27
Scott Harris
1263
add a comment |
Yes there is:
=TEXT(A1,"mm/dd/yy")
Alternatively, you can custom format the actual date cell (A1 in the formula above) by right clicking → Format Cells → Custom and entering the same format (mm/dd/yy).
edited Sep 8 '18 at 9:37
phuclv
8,96063889
answered Aug 25 '14 at 21:27
Scott Harris
1263
Yes there is:
=TEXT(A1,"mm/dd/yy")
Alternatively, you can custom format the actual date cell (A1 in the formula above) by right clicking → Format Cells → Custom and entering the same format (mm/dd/yy).
edited Sep 8 '18 at 9:37
phuclv
8,96063889
answered Aug 25 '14 at 21:27
Scott Harris
1263
edited Sep 8 '18 at 9:37
phuclv
8,96063889
edited Sep 8 '18 at 9:37
phuclv
8,96063889
edited Sep 8 '18 at 9:37
phuclv
8,96063889
8,96063889
answered Aug 25 '14 at 21:27
Scott Harris
1263
answered Aug 25 '14 at 21:27
Scott Harris
1263
answered Aug 25 '14 at 21:27
Scott Harris
1263
1263
add a comment |
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f802089%2fformatting-date-in-excel-for-csv-upload%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
3
First, CSV is text. Second, now that you know that, open the CSV in notepad and paste a line here (replace any identifiable info first)
– krowe
Aug 24 '14 at 2:32