Date format in Excel file imported to Numbers.

Discussion in 'iPad General Discussions' started by OtleyLad, Mar 10, 2013.

  1. OtleyLad
    Offline

    OtleyLad iPF Noob

    Joined:
    Mar 10, 2013
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    United States
    Ratings:
    +0 / 0
    I have imported an Excel spreadsheet into Numbers. A column of dates in Excel (e.g. Tues March 2 2013) appears in Numbers as a number (e.g. 41013).
    Can I prevent this from happening? Or can I convert the numbers back to a date format in Numbers?
  2. Blue92
    Offline

    Blue92 iPad Fan

    Joined:
    Mar 4, 2012
    Messages:
    169
    Thanks Received:
    15
    Trophy Points:
    18
    Location:
    Central Ohio
    Ratings:
    +16 / 0
    You should be able to just change the format of the cell(s) back to a date format.
  3. OtleyLad
    Offline

    OtleyLad iPF Noob

    Joined:
    Mar 10, 2013
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    United States
    Ratings:
    +0 / 0
    I agree I should be able to do as you say, but it does not work.
    I have got around it by inserting a new column and populating it with "Dec 30 1899" plus the number from the imported column.

Share This Page

Search tags for this page

dropbox date format excel

,
excel dates changed to dollars on iphone
,
excel for ipad how to change date format
,

why does date format change in excel to dollar when sent to iphone

,
why does the date on my excel spreadsheet change to dollars on ipad