[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Excel formatting issue

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.
1 Solution
Farzad AkbarnejadCommented:
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.

Outside of requesting they paste special/values, you'd probably need to utilize VBA.  Locking the cells will not work in this situation.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now