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.
Formula to convert date to number. up vote 9 down vote favorite. I would like to know the formula to convert a date in 10/26/2013 to 41573 number as done in excel. Like how 10/26/2013 is converted to 41573.f you change the format of the cells to General then this will show the date value of a cell as behind the scenes Excel saves a date as the number of days since 01/01/1900. If your date is text and you need to convert it then DATEVALUE will do this: share | improve this answer. answered Nov 1 '13 at 8:05.