Re: Slightly OT: question about dates in Numbers app

2018-02-27 Thread Jonathan Cohn
Alex, I looked at the Runners log template in Numbers thinking that perhaps it would have an auto-insert date function, but no luck there. There is a Insert Date/Time menu item that you could assign a hot key to. Take Care, Jonathan Cohn > On Feb 26, 2018, at 8:01 PM, Alex Hall

Re: Slightly OT: question about dates in Numbers app

2018-02-26 Thread Phil Halton
I learned to write formulas in the numbers app using the extensive health system which describes functions formulas and all the syntax they’re in. I did have a lot of experience in Excel spreadsheet in and he did carryover. I was also a programmer many moons ago and I suppose that helps a bit

Re: Slightly OT: question about dates in Numbers app

2018-02-26 Thread David Chittenden
Many formuli work the same in Numbers as they do in Excel. I would try the Excel instructions and see if they work for Numbers in your use case. Kind regards, David Chittenden, MSc, MRCAA Email: dchitten...@gmail.com Mobile: +61 488 988 936 Sent from my iPhone > On 27 Feb 2018, at 11:01, Alex

Re: Slightly OT: question about dates in Numbers app

2018-02-26 Thread Alex Hall
My day job is part coder, part IT guy, so formulas don't bother me. I'm not sure where to start, though, and I could only find threads about my question that talked about Excel, not Numbers. -- Alex Hall > On Feb 26, 2018, at 09:00, Phil Halton wrote: > > That depends,

Re: Slightly OT: question about dates in Numbers app

2018-02-26 Thread Phil Halton
That depends, how good are you at writing spreadsheet formulas? In my experience you probably be better off just manually entering the date, such as 2/26, for February 26. It is, after all, just one more field to fill-in as opposed to some fairly tricky formula writing. Sent from my IPhone >

Slightly OT: question about dates in Numbers app

2018-02-25 Thread Alex Hall
Hi all, This is a bit off topic, but I can't think of a better place for a Numbers question. On macOS, I need to keep a log for the next few weeks, updated daily. I'm making a spreadsheet, and I'd like the first column to fill itself with the current date whenever I enter values on the row.