Numbers Problem

Discussion in 'Mac Basics and Help' started by Cap41, Feb 20, 2009.

Most Liked Posts
  1. Cap41, Feb 20, 2009

    Cap41 macrumors 6502

    Joined:
    Nov 19, 2008
    #1
    I use office08 for excel...some of the boxes i use are formmated so when i enter the date say 22feb hit enter, it corrects it to read Feb. 22.

    When i import into numbers, and try to do it, there is no foramt for that cell, i type 22feb, and that s what shows in the cell, Is there a way of formatting these to do the way the excel spreedsheet works?
     
    share
    + Quote Reply
  2. jive turkey, Feb 21, 2009

    jive turkey macrumors 6502

    Joined:
    Mar 15, 2008
    #2
    If I understand you correctly. . . You can format from the tool bar. Use the the drop down list found at the end of the format boxes (1.0, $, %, etc). You can select date from this list.

    However, the easiest way for what you want is probably to use the Inspector window. From there you can assign a custom date format that should auto correct entries like yours, but you may have to put a space between the day and month. (I just tested what I think you are trying to do, and I got 22 feb to auto format, but 22feb would not.)
     
    share
    + Quote Reply
  3. Cap41, Feb 21, 2009

    Cap41 thread starter macrumors 6502

    Joined:
    Nov 19, 2008
    #3
    I think you solved my problem. Thank you very much... a simple space corrected everything...thx again.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page