+ Reply to Thread
Results 1 to 3 of 3

Date Format Issues in Excel for Mac

Hybrid View

  1. 11-16-2018, 02:46 AM #1
    the_edje
    the_edje is offline
    Registered User
    Join Date
    11-16-2018
    Location
    Dubai
    MS-Off Ver
    Excel for Mac 2011
    Posts
    1

    Date Format Issues in Excel for Mac

    Hi,

    I have an issue which is driving me crazy..

    In Excel for Mac 2011, when using dates it seems that a new format is being used in the formula bar. For example, instead of displaying 16/11/2018 the date is displayed as 16M11M2018.

    This is a problem as I need to load lots of data into a portal which does not recognise this format as a date. I can make the date format display however I want in the actual spreadsheet, it's just in the formula bar where I have the issue.

    Anyone know how to resolve this? I've attached a screenshot to show what I mean.

    Thanks

    Lee
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 11-16-2018, 02:51 AM #2
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,279

    Re: Date Format Issues in Excel for Mac

    Kindly attach file, its more helpful.

    atul

    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
    Reply With QuoteRegister To Reply
  3. 11-16-2018, 08:00 AM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,278

    Re: Date Format Issues in Excel for Mac

    I don't have a MAC so this could be complete rubbish BUT, if the data is displayed in the formula bar as 16M11M2018 or 31M7M2020, it is nothing to do with formatting. That IS the data.

    An unformatted date would show as a 5 digit number and, formatted, it would show as a date with whatever format you've specified. It is unlikely that you could get a date format with Ms in like that as the M would be considered a part of the Month format. Two Ms would show the month as a two digit number; three Ms would show as a short alpha description, for example, Nov; and three Ms would show as a full alpha description, for example, November.

    If you have a TRUE date in the cell, for example, 16/11/2018 you could get it to show as 16M11M2018 in the cell using a Custom Format: dd"M"mm"M"yyyy. However, it would still show as the date 16/11/2018 in the formula bar.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2016, 08:07 AM
  2. [SOLVED] Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-11-2016, 07:57 AM
  3. [SOLVED] Date format from textbox to filter - text to date formate issues
    By Wales MB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-26-2015, 07:36 AM
  4. Date format issues in Excel 2013
    By c0ld in forum Excel General
    Replies: 1
    Last Post: 04-23-2014, 12:45 PM
  5. Date format issues
    By robertrocks in forum Excel General
    Replies: 2
    Last Post: 11-05-2010, 01:32 PM
  6. Date format issues
    By sketchgal in forum Excel General
    Replies: 2
    Last Post: 07-20-2010, 07:33 AM
  7. [SOLVED] Date Format Issues Access to Excel
    By RC in forum Excel General
    Replies: 3
    Last Post: 06-13-2006, 06:35 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1