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.
Convert date to weekday name or month name with Text function. Microsoft Excel's Text function can help you to convert date to its corresponding month name or weekday name easily. In a blank cell, please enter this formula =TEXT(A1,mmmm), in this case in cell C1. , and press the Enter key. And then drag this cell's AutoFill handle to the range as you need. And the date have been converted to month name.