<div>
Hello,<br />
You can record a macro and do your appropriate formatting on columns. After receiving worksheets from the people you can run macro on those sheets and get proper format.<br />
<br />
-FA
</div>


Hello,
You can record a macro and do your appropriate formatting on columns. After receiving worksheets from the people you can run macro on those sheets and get proper format.

-FA

<div>
<div class="content wysiwyg-content">
I have an excel sheet that needs to have data in a specific format for different columns.<br />
however I need to pass this excel sheet around to people and then have completed sheets sent to me.<br />
It can be a regular worksheet or template. &nbsp;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).<br />
Is there a way to force specific formats?<br />
The problem seems to be people pasting existing data and using the source formatting which overrides mine.
</div>
</div>


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.

Excel formatting issue

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.