Trying to export customer number from a table into excel. If use the XL button they remain as text but if I use a macro these turn to a number and drop the leading zero. If was only 1 table I would use the XL button but there is 20 tables and is time consuming.
Has anyone any ideas on what I can add to the macro to keep table as text?
My object is a chart rather and a table as Total Sales and Qty is a calculation, but will see if I can change this somehow to let me use a chart instead. But if you have any further guidance would greatly appreciate it
Example works great for the sample data that I had above. Thank you