Date format in Excel file imported to Numbers.

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

  1. OtleyLad

    OtleyLad
    Expand Collapse
    iPF Noob

    Joined:
    Mar 10, 2013
    Messages:
    2
    Thanks Received:
    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
    Expand Collapse
    iPad Fan

    Joined:
    Mar 4, 2012
    Messages:
    245
    Thanks Received:
    40
    You should be able to just change the format of the cell(s) back to a date format.
     
  3. OtleyLad

    OtleyLad
    Expand Collapse
    iPF Noob

    Joined:
    Mar 10, 2013
    Messages:
    2
    Thanks Received:
    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