Lets say I have dates on MS Excel, for another project i need all dates cells as text.
So the date cells are currently formatted "custom" as "mmddyy". When I change the format to text it converts the day to a numbers. How would I prevent that? So I want the cell to be formatted as text but showing the date as mmddyy