Convert date in Excel column to text or string format

excel

#1

Hi,
I am downloading dumps from SAP which has data called “FEB1” in few columns. But while editing the data and pasting it, it is getting converted as “Febraury 01” or “01-02-2018”. How do I retain the data as “FEB1”?


#2

hi @nikhilaramesh08

StrDate.tostring(“MMMD”)

Thanks
Ashwin S