Notifications
Clear all
Topic starter
Can we have a macro to convert number format to text format in Column A then save to CSV file structure for upload to Bank System ? Pls refer attached sample [ some number transformed after down load from Bank System]
Posted : 01/06/2018 4:15 am
Topic starter
Sorry forget attachment
Posted : 01/06/2018 4:20 am
Hi David
You can convert the numbers to text format using the TEXT formula.
My macro will export your data to CSV but not sure if the result is what you wanted.
You may have to tweak the macro a little.
Hope this helps.
Sunny
Posted : 02/06/2018 9:12 am
Topic starter
Thansk Sunny the idea, it helps a lot.
Will try tweak the macro you so generous offer a little to suit for the Bank System upload.
Posted : 04/06/2018 8:30 pm
