Hi
There should be no difference in formatting from an earlier version of Excel to a later vesion.
However I would suggest that the first thing to do is to open the files created in earlier versions of Excel and then save them in the current version.
This may resolve your issues.
Failing that you may need to reassign the formatting once you have saved in the latest version.
Hope this helps.
Good luck.
Tony(OTPM)