Results 1 to 9 of 9

Date format in cell differs from date format in formula bar

Threaded View

  1. 08-18-2016, 04:55 PM #1
    aziliza
    aziliza is offline
    Registered User
    Join Date
    08-18-2016
    Location
    Chicago
    MS-Off Ver
    2007
    Posts
    4

    Date format in cell differs from date format in formula bar

    I am trying to upload a file into a program. The date format must be mm/dd/yy it also cannot be a text field, it must be date. The cell shows correctly but in the formula bar I am seeing mm/dd/yyyy. I have also updated my region and date settings to show short date of mm/dd/yy. I have also attached the error message I receive. Can anyone help?
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« 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. Converting from the 1904 date format to the 1900 date format without losing data
    By Patty McJorst in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2020, 12:53 PM
  2. [SOLVED] How to convert a cell (that contains a date but not in date format) into date format?
    By Karthikeyannb in forum Excel General
    Replies: 1
    Last Post: 12-09-2014, 05:06 AM
  3. Date Format Of User PC Changes Display format date of Excel File after update
    By waihar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2014, 03:09 AM
  4. [SOLVED] Require vba or formula for convert general format data in date format
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2013, 03:53 AM
  5. Converting Twitter date format to standard Excel date format to use with WEEKDAY function
    By dharmis in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-08-2013, 11:06 AM
  6. Need Formula/VBA Code to convert date in String Format to Normal Date format
    By Karthik Sen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2012, 04:54 AM
  7. Using a Date format in a cell instead of a Text format to support a formula.
    By avidcat in forum Excel General
    Replies: 2
    Last Post: 10-02-2010, 04:41 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1