I have a Dynamic Table in excel 2013. The date is entered into the Table by a Userform. All ok until I add the 2nd record into the Table. All the numeric values in the second record are being stored as text values. If I add a 3rd record these values remain as numeric but my Table stops being Dynamic. Can anyone explain how to stop this happening?
Bookmarks