•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Macro to remove a decimal, but keep the decimal points?
The data we use is exported from an accounting software and is exported as a .txt file. The bank will only accept .csv, which we can convert the .txt to. The problem is the dollar amounts export with the decimal (it's about 800 rows of data that needs to be changed), but the bank system won't accept decimals within the file. Its system will place the decimal when it processes the charges.
For example: I need to turn 672.35 into 67235 or 100.00 to 10000 (times 800 rows of varying dollar amounts).
I understand that working in a .csv is where it gets tricky and I can't find a clear answer myself on how to get this done (or if I can).
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#digital transformation in spreadsheet software
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#decimal removal
#csv conversion
#accounting software