Oct 09 2020 09:06 PM
Hi, How do we convert $10,000,000 to 10000000 in a csv/excel file?
Oct 09 2020 09:29 PM
@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.
Oct 10 2020 06:05 AM