I have an excel sheet that needs to have data in a specific format for different columns.
however I need to pass this excel sheet around to people and then have completed sheets sent to me.
It can be a regular worksheet or template. At the moment when I get them back the data is in all different formats for some of the columns(date are yyyy-dd-mm instead of mm/dd/yyyy kind of stuff).
Is there a way to force specific formats?
The problem seems to be people pasting existing data and using the source formatting which overrides mine.