Hello,
I need to format a particular csv column as currency. It holds values such as 145, 17.5, 11 etc. I want to convert them to £145.00, £17.50, £11.00 etc.
I know from some Googling that
"{0:C2}" -f
Should achieve this but how do I script this to convert the entire column?
Any help gratefully received.
Thank you.