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.
1 In your Excel worksheet, format the dates exactly as you want the text strings to look like. 2  Select all of the dates you want to convert and press Ctrl+C to copy them. 3  Open Notepad or any other text editor, and paste the copied dates there.4  Notepad automatically converts the dates to the text format.f you don't mind the default format, then perform the following steps: 1  In your Excel spreadsheet, select all of the dates you want to change to text. 2  On the Data tab, find the Data Tools group, and click Text to Columns. 3  On step 1 of the wizard, select the Delimited file type and click Next.