+ Reply to Thread
Results 1 to 2 of 2

how to cell convert in date format?

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    Ahmedabad, Gujarat, India
    MS-Off Ver
    Excel 2007
    Posts
    24

    how to cell convert in date format?

    i have copy some data from pdf file into excel..
    but that data is not properly fiiled in excel.. they look like date format (i.g 31-03-2015) but not in date format...
    so i edit every cell with F2 than enter... F2 than enter
    is any sort formula for edit(F2) because i have plenty of row

    thanks in advance
    Thanks & Regards,
    Nikesh Mak

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,127

    Re: how to cell convert in date format?

    Add zero to them... =A1+0 and format as date.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. i have to convert the csv file date format to excel date format
    By arindamsenaxa in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-17-2015, 03:37 AM
  2. Replies: 1
    Last Post: 12-09-2014, 05:06 AM
  3. Convert cell contents to date format
    By banks334 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2013, 01:29 PM
  4. Cannot convert date (which is in text format) to date in numeric format
    By geniuspro in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-19-2012, 09:21 AM
  5. 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
  6. Convert cell category from Date to Text, keeping mm/dd/yyyy format
    By chachie22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2011, 05:00 PM
  7. Replies: 1
    Last Post: 03-15-2006, 04:32 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