Convert date in Excel column to text or string format

Help
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