Excel formatting issue

Posted on 2012-08-15
Last Modified: 2012-08-29
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.
Question by:casit
    LVL 14

    Expert Comment

    by:Farzad Akbarnejad
    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.

    LVL 3

    Accepted Solution

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now