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.
To enter a date in Excel, use the / or - characters. To enter a time, use the : (colon). You can also enter a date and a time in one cell. Note: Dates are in US Format.Months first, Days second. This type of format depends on your windows regional settings.o add a number of years, months and/or days, use the DATE function. Note: the DATE function accepts three arguments: year, month and day. Excel knows that 6 + 2 = 8 = August has 31 days and rolls over to the next month (23 August + 9 days = 1 September).