I import data into a CSV file then convert it to excel xls. One column of data has a comma in the number like this 19,456 which actually that is supposed to be 194.56 (yes the mainframe is screwed up and sends the data with the comma in the wrong position.) Anyhow, I have to convert this to a currency figure so using the following:
=left(b2,3)&"."&right(b2,2)
I get 194.56 then I copy and paste values over it to get rid of the formula, but then i cannot get the $ formatting to work. How do I get the currency or accounting or dollar formatting to work on the resulting cell?
Eddie G.
=left(b2,3)&"."&right(b2,2)
I get 194.56 then I copy and paste values over it to get rid of the formula, but then i cannot get the $ formatting to work. How do I get the currency or accounting or dollar formatting to work on the resulting cell?
Eddie G.