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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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
97
Micron
M
J
  • Solved
Date format mm/dd/yyyy to dd/mm/yyyy
Replies
5
Views
763
jues
J
G
  • Solved
History of Dates to be traced in Excel (2010) in DD/MM/YYYY format
2
Replies
11
Views
357
MARK858
MARK858
G
  • Question
How to fix Userform dd/mm/yyyy change to mm/dd/yyyy
Replies
1
Views
522
George06
G
T
  • Solved
VBA UserForm date format reversal dd/mm/yyyy into mm/dd/yyyy
Replies
3
Views
753
6StringJazzer
6StringJazzer

Forum statistics

Threads
1,214,593
Messages
6,120,435
Members
448,961
Latest member
nzskater

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