Here is the data I am trying to clean.
Income Expense
Staff Salary 0 83 869
Money Transfer 350 000 0
Repair work 0 21 361
Electricity 0 11 360
Water 0 4 544
I need to convert 350 000 to $350,000, 83 869 to $83,869, etc
If I...
I am importing raw data from an on line game I play; I import a string format that I need to convert to a number (currency).
for example: 203 101 is the string that gets imported
I tried doing the find " " and replace with "" first but that does not work. I have been clicking inside the text...
I have a rather large list of items I want to timestamp. I have a column with all cells values at =now().
Is there a way I can "program" my mouse key to copy the cell and paste as a value with one click instead of having to copy then select "paste special values" then CHOSE "select special...
I have built a Pareto Chart with a dual axis. My Pareto line is based on the accumalative % and looks similar to the one I saw in Wikipedia and on the Pareto Chart template this website offers. Sadly, my boss wants the Pareto line to start at the top of the bar of my first data element. I would...