Forum

Notifications
Clear all

Converts a date to text in an imported file

2 Posts
2 Users
0 Reactions
125 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

I have an imported table that says 11-15 and it has a date, how to change it to text, and that after the change it will remain 11-15 and will not change to the serial number of the date 42309?

 
Posted : 25/11/2017 3:03 am
(@sunnykow)
Posts: 1417
Noble Member
 

You could try =TEXT(A1,"mm-dd")

 
Posted : 25/11/2017 3:39 am
Share: