+ Reply to Thread
Results 1 to 2 of 2

How to fomat these cells

  1. #1
    Registered User
    Join Date
    12-01-2004
    Posts
    70

    How to fomat these cells

    Hi All,

    In one column I have date in m/d/yyyy format and in another column I have it as mm/dd/yyyy and I want to make both the column in the same format so I can compare them, I tried formatting with Date and selecting the format but it doesn't work, so how do I do that?

    Thank You for any tips

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,677

    Re: How to fomat these cells

    Their is no apparent reason why you should not be able to format both cells the same way as long as they are truly dates.

    Are you sure they are dates? You can test it by using = ISNUMBER(A1). Does this produce true? If false, then the data is not a date and you'll have to convert.

    You can also select the cells and select Ctrl + Shift ~

    If they are dates, this will produce a number as dates are just numbers starting from 1 Jan 1900. Today is 43025
    Last edited by jeffreybrown; 10-17-2017 at 08:53 AM.
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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