Converting to numbers

Copper Contributor

Hi, How do we convert $10,000,000 to 10000000 in a csv/excel file?

4 Replies

@Samit1972 If the $10,000,000 is a number in Excel, you can format it as "General" for it to show as 10000000. Then save as CSV and it will show as 10000000 there as well.

 

If the $ amount is in fact a text string, get rid of the $ sign first (Use Find&Replace, Ctrl-H: Find "$", Replace with ""). Then convert to a number using VALUE to get rid of the commas, or perform another Find&Replace to replace commas with nothing. Now you can save as CSV, similar to above.

@Riny_van_Eekelen Thanks a ton. That did the trick

@Samit1972 

 

Hi there,

 

Please take attached files into your consideration.

Good luck

 

@Ilgar_Zarbaliyev Thank you. That was very helpful