Saving as csv

R

rplim2016

Board Regular
Joined
Jun 28, 2016
Messages
76
Hi Excel gurus,

Excel csv format

when i save my date as yyyy-mm-dd, as text. Then i open the file, it converts into yyyy/mm/dd which is not supposed to be.

please advise how to keep the “-“ format.


Cheers!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Sort by date Sort by votes
Hi excel gurus, can you help me please?

On column A, pure dates. But upon saving then opening the format comes back to yyyy/mm/dd :(
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
2029 rule when extract saved as CSV
Replies
4
Views
197
Micron
M
P
  • Question
how to allow only specific date format in a cell of excel
Replies
4
Views
252
prakashkumar
P
B
  • Question
Copy, paste based on excel sheet name
Replies
1
Views
73
eiloken
E
J
  • Solved
Date format mm/dd/yyyy to dd/mm/yyyy
Replies
5
Views
983
jues
J
B
  • Question
format Date in a Userform TextBox (yyyy-mm-dd) from data entered in a cell
Replies
9
Views
231
dmt32
D

Forum statistics

Threads
1,216,769
Messages
6,132,603
Members
449,739
Latest member
alexismce

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top