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.
Converting Text to Numbers. 1  In Excel 2003, on the Format menu, click Cells. 2  In Excel 2007 or later, click the arrow to the bottom right of the Font section on the ribbon to call up the Format Cells dialog box. 3  On the Number tab, click General under Category, and then click OK. Select the cell in which you typed 1, and then right click and choose Copy. 2  Select the cells with the values that you want to convert to numbers. 3  Right click and choose Paste Special. 4  Under Operation, click Multiply and then click OK.