Results 1 to 6 of 6

Date Format

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2011
    Location
    US
    MS-Off Ver
    Excel Mac 2011
    Posts
    31

    Date Format

    I have a strange data format on the attached example. It is in euro in the data sheet (dd/mm/yy) and I want it to be US (mm/dd/yy). I tried changing the date to a number and using the =date function. That does not work. The number is strange. When I graph with the current date formatting I get the strange value on the X axis instead of the date displayed in the cell.

    Can someone help me correctly format this data to mm/dd/yy hh:mm:ss?
    Attached Files Attached Files

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