Sorry if this seems like a silly question but todya is my first every macro experience!
I am tryimg to create a macro that coverts a string of numbers into a sum:
I.e. I want to turn
£7,296.25, £2,245.00, £1,122.50, £561.25
into
=7296.25+2,245.00+1122.50+561.25
So far I have added in thre plus signs and am getting variable results using the format facilities to make it ignore the commas within the number. But I can't work out at all how to add in the equals sign to the start of the string of numbers. Am sure it must be simple?
Thank you!
I am tryimg to create a macro that coverts a string of numbers into a sum:
I.e. I want to turn
£7,296.25, £2,245.00, £1,122.50, £561.25
into
=7296.25+2,245.00+1122.50+561.25
So far I have added in thre plus signs and am getting variable results using the format facilities to make it ignore the commas within the number. But I can't work out at all how to add in the equals sign to the start of the string of numbers. Am sure it must be simple?
Thank you!