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:
    160
    Thanks Received:
    14
    Trophy Points:
    18
    Location:
    Central Ohio
    Ratings:
    +15 / 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
date format iphone excel
,
date in excel files showing dollar signs on dropbox
,

dropbox date format excel

,
excel changing dates to numbers iphone
,
excel date format changes to dollar on iphone
,
excel dates changed to dollars on iphone
,
excel dates showing dollars ipad
,
excel dates shown as numbers on iphone
,
excel file show date as $ in iphone 4
,
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