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.
Letâs take a look. This pivot table shows total sales by product. Letâs add the date field as a column, then group the date to show sales by year. When you first add a date field as a row or column label, Excel will break out the values by every value in the field.To group a date field, first select one of the dates.Then right-click and choose Group from the menu. Excel will display a grouping dialog box, with a list of date and time units.etâs add the date field as a column, then group the date to show sales by year. When you first add a date field as a row or column label, Excel will break out the values by every value in the field. To group a date field, first select one of the dates. Then right-click and choose Group from the menu.