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.
1 If source data is just numbers, then choose General. 2  If source data is a date and it has to be converted from string to its original format, choose date. 3  Date will default to mm/dd/yyyy. 4  If you want in a different format, choose other options near the Date option.his topic explains the correction process with the example by (1) converting number stored in string format back to number and with a string to date conversion. (Also has corresponding VBA Macro Code).