Retail Sales Assistant Salary. (United Kingdom). The average pay for a Retail Sales Assistant is Â£6.41 per hour. Pay for this job does not change much by experience, with the most experienced earning only a bit more than the least.
If you want to convert excel dates to text values (for your report or some other purpose), you can use the TEXT formula like this: =TEXT(A1,DD-MMM-YYYY) will convert date in Cell A1 to DD-MMM-YYYY format. You can pass any other date / time formats to TEXT formula as well.
Here's how: 1  Put the text date from your CSV into A1 in a new worksheet. 2  In A2, put this formula: 3  The value in A1 is now a valid date in Excel.  Then, format the cell with a custom date 1  format. The date value in A2 should now be formatted as a date plus time, like this: 2013.09.30 09:36:14. 213.