I have an excel sheet that was imported via txt file but I do not have a copy of the txt file and our programmer is out this week. I hope someone can assist. Currently it is listed as DD MM YY (with spaces) and I need it to convert to dd-mon-yy.
where Nx is the location of your data (N being the column and x being the row). The Trim function is used to remove any unwanted spaces that are there but you cannot see and might otherwise much this up.
Now you should have a date and you can format the cell (or whole column) using the Format function and choosing the Number tab - there are some defaults available for Date, but if you cannot find the one you want then choose Custom and type in dd-mmm-yy.
Now you can shuffle your columns around and hide the original.