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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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

O
  • Solved
Convert timestamp format to DD/MM/YYY
2 3 4
Replies
35
Views
424
Joe4
Joe4
H
  • Question Question
Macro to Open File and limit selection where files contains "Parts" in C
Replies
4
Views
270
howard
H
H
  • Question Question
Date from CSV file not copying & pasting correctly. Day and Month are reversed.
Replies
1
Views
192
jkpieterse
jkpieterse
G
  • Question Question
Date conversion
Replies
4
Views
497
MARK858
MARK858
B
  • Question Question
Validate data input in DD/MM/YYYY hh:mm format
Replies
3
Views
564
Asbestos_Jen
Asbestos_Jen

Forum statistics

Threads
1,224,743
Messages
6,180,687
Members
452,994
Latest member
Janick

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