1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

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:
    153
    Thanks Received:
    13
    Trophy Points:
    18
    Location:
    Central Ohio
    Ratings:
    +13 / 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