+ Reply to Thread
Results 1 to 3 of 3

Mac converting excel cell formats from general format to date format

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    Maryland
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2305 Build 16.0.16501.20074) 64-bit
    Posts
    54

    Mac converting excel cell formats from general format to date format

    Hello,

    I have created a pricing model using office 2013 (windows) and saved as Microsoft Excel Macro-Enabled Worksheet and it works great. I have it accessible on sharepoint and a few of my coworkers have used the bid calculator using a Mac via Amazon Workspaces which is actually a window based VM (not using excel for mac sw). Every time they update the pricing model it converts all general cell formatting to date formatting and it blows up the entire price model. Has anyone had this problem and if so is there a fix?

    Your comments/advise would be much appreciated.

    Mark R.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Mac converting excel cell formats from general format to date format

    Yikes. Can you not allow them to modify the pricing model, and instead allow them to update a data workbook that is then reported on in the model? That way they can update whatever workbook needs updating but then they cant modify the reporting piece.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    10-29-2013
    Location
    Maryland
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2305 Build 16.0.16501.20074) 64-bit
    Posts
    54

    Re: Mac converting excel cell formats from general format to date format

    Good idea but unfortunately the users need to manipulate the price model in order to accomplish their profit goals.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Converting data general column to UK Date format in Excel 2007 - vba
    By Sailaja A in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2013, 06:59 AM
  2. Replies: 5
    Last Post: 02-08-2013, 11:06 AM
  3. Converting DATE format to GENERAL format?
    By timtim in forum Excel General
    Replies: 9
    Last Post: 08-19-2011, 02:38 AM
  4. Converting all date formats to one single standard format.
    By booo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-25-2010, 07:14 PM
  5. Converting General format in to HH:MM format
    By Big Mark in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2007, 10:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1