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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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

H
  • Question Question
Macro to Open File and limit selection where files contains "Parts" in C
Replies
4
Views
231
howard
H
H
  • Question Question
Date from CSV file not copying & pasting correctly. Day and Month are reversed.
Replies
1
Views
167
jkpieterse
jkpieterse
G
  • Question Question
Date conversion
Replies
4
Views
424
MARK858
MARK858
B
  • Question Question
Validate data input in DD/MM/YYYY hh:mm format
Replies
3
Views
443
Asbestos_Jen
Asbestos_Jen
S
  • Solved
Excel shows wrong date format in cell
Replies
5
Views
86
dmt32
D

Forum statistics

Threads
1,223,636
Messages
6,173,483
Members
452,516
Latest member
archcalx

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