Converting to numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-1766749%22%20slang%3D%22en-US%22%3EConverting%20to%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766749%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20How%20do%20we%20convert%20%2410%2C000%2C000%20to%2010000000%20in%20a%20csv%2Fexcel%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1766749%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766767%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20to%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766767%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F827142%22%20target%3D%22_blank%22%3E%40Samit1972%3C%2FA%3E%26nbsp%3BIf%20the%20%2410%2C000%2C000%20is%20a%20number%20in%20Excel%2C%20you%20can%20format%20it%20as%20%22General%22%20for%20it%20to%20show%20as%2010000000.%20Then%20save%20as%20CSV%20and%20it%20will%20show%20as%2010000000%20there%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20%24%20amount%20is%20in%20fact%20a%20text%20string%2C%20get%20rid%20of%20the%20%24%20sign%20first%20(Use%20Find%26amp%3BReplace%2C%20Ctrl-H%3A%20Find%20%22%24%22%2C%20Replace%20with%20%22%22).%20Then%20convert%20to%20a%20number%20using%20VALUE%20to%20get%20rid%20of%20the%20commas%2C%20or%20perform%20another%20Find%26amp%3BReplace%20to%20replace%20commas%20with%20nothing.%20Now%20you%20can%20save%20as%20CSV%2C%20similar%20to%20above.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1767190%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20to%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767190%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThanks%20a%20ton.%20That%20did%20the%20trick%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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