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 Select all of the dates you want to convert and press Ctrl+C to copy them. 2  Open Notepad or any other text editor, and paste the copied dates there. 3  Notepad automatically converts the dates to the text format. 4  Press Ctrl+A to select all text strings, and then Ctrl+C to copy them.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.