Date format in Excel file imported to Numbers.

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

  1. OtleyLad

    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

    Blue92 iPad Fan

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

    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
date in excel files showing dollar signs on dropbox
,

dropbox date format excel

,
excel changing dates to numbers iphone
,
excel dates changed to dollars on iphone
,
excel dates showing dollars ipad
,
excel for ipad how to change date format
,
how to change 2/2013 to 2013-02 in excel
,
ipad excel date field changed to dollars
,

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