I have a curious challenge I'm trying to overcome and I could do with some support.
I'm converting a set of data that consists of timesheet information into a table using vba. The column headings pre-conversion are in date format, but the underlying data is a number (i.e. if I convert it into a number format it changes from xx/xx/xxxx to xxxxx.xx
After the table has been created, the column headings no longer have the underlying number format.
I need to retain that underlying format. Is there a way of doing that?
I'm converting a set of data that consists of timesheet information into a table using vba. The column headings pre-conversion are in date format, but the underlying data is a number (i.e. if I convert it into a number format it changes from xx/xx/xxxx to xxxxx.xx
After the table has been created, the column headings no longer have the underlying number format.
I need to retain that underlying format. Is there a way of doing that?
