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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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
144
Micron
M
P
  • Question
how to allow only specific date format in a cell of excel
Replies
3
Views
109
Anthony47
A
J
  • Solved
Date format mm/dd/yyyy to dd/mm/yyyy
Replies
5
Views
815
jues
J
G
  • Solved
History of Dates to be traced in Excel (2010) in DD/MM/YYYY format
2
Replies
11
Views
417
MARK858
MARK858
G
  • Question
How to fix Userform dd/mm/yyyy change to mm/dd/yyyy
Replies
1
Views
548
George06
G

Forum statistics

Threads
1,215,339
Messages
6,124,375
Members
449,155
Latest member
ravioli44

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