Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.apps > #31290

Re: Date entry in Numbers

Show all headers | View raw

In article <250820152122526255%michelle@michelle.org>, Michelle Steiner
<michelle@michelle.org> wrote:

> In article <d44q74Fjsr8U1@mid.individual.net>, TaliesinSoft
> <taliesinsoft@me.com> wrote:
> 
> > On 2015-08-26 02:07:44 +0000, David Empson said:
> > 
> > [in response to Michelle's wanting to insert a date in a Numbers
> > spreadsheet]
> > 
> > > In Numbers 2.x (from iWork '09):
> > > 
> > > Insert menu > Date & Time
> > 
> > I'm running Numbers 3.5.3 and the same Insert works.
> 
> Never noticed that before.  However, it does not obey the formatting
> for the cell  The cell is formatted as mm/dd/yy, but inserting from the
> menu puts the entire long date into the cell.

At that point you have two options to format the date the way you want
it:

1. Click again in the cell. A pop-up window allows you to set the
format.
2. Display the formatting side-panel (View -> Inspector -> Format).
Select the Cell panel. Select the date format.

-- 
Jim Gibson

Back to comp.sys.mac.apps | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Date entry in Numbers Michelle Steiner <michelle@michelle.org> - 2015-08-25 18:21 -0700
  Re: Date entry in Numbers dempson@actrix.gen.nz (David Empson) - 2015-08-26 14:07 +1200
    Re: Date entry in Numbers TaliesinSoft <taliesinsoft@me.com> - 2015-08-25 22:30 -0500
      Re: Date entry in Numbers dempson@actrix.gen.nz (David Empson) - 2015-08-26 15:41 +1200
      Re: Date entry in Numbers Michelle Steiner <michelle@michelle.org> - 2015-08-25 21:22 -0700
        Re: Date entry in Numbers Jim Gibson <JimSGibson@gmail.com> - 2015-08-26 17:59 -0700
          Re: Date entry in Numbers Michelle Steiner <michelle@michelle.org> - 2015-08-26 21:43 -0700

csiph-web