Results 1 to 5 of 5

date format cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-06-2014
    Location
    iran
    MS-Off Ver
    2016
    Posts
    110

    date format cell

    hi i have an excel data that first column is date and secound and third column is coresponding time and height
    how can i changed all the format of date in to one format dd/mm/yyyy
    because some of them is in mm/dd/yyyy format. i attached image and excel file.
    (dd/mm/yyyy time height)
    thanks so much
    regard
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-11-2015, 06:06 AM
  2. Replies: 2
    Last Post: 06-02-2015, 08:42 AM
  3. Show Error when a cell with number format change to date format
    By delroba in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2015, 02:57 AM
  4. Replies: 1
    Last Post: 12-09-2014, 05:06 AM
  5. Replies: 3
    Last Post: 11-23-2013, 06:21 AM
  6. Replies: 1
    Last Post: 11-01-2012, 10:37 AM
  7. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1