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.
Figure 2: You can use the VALUE function to convert numbers stored as text to usable values. A somewhat simpler approach involves using the Paste Special, Multiply command. In any version of Excel, enter the number 1 in a blank cell and then copy that value to the clipboard.Next, select the range of values stored as text, right-click, and choose Paste Special, Multiply, and then OK. You can then clear 1 from the worksheet cell.Figure 3: You can also convert numbers stored as text to values by multiplying the cells by 1.The easiest way to convert a range of values to text, though, involves using the Text to Columns feature.ou can then clear 1 from the worksheet cell. Figure 3: You can also convert numbers stored as text to values by multiplying the cells by 1. The easiest way to convert a range of values to text, though, involves using the Text to Columns feature.