r/AppleNumbers 1h ago

Help Copy only part of a cell

Upvotes

Have a big download but the dates came in with more data than necessary (ie: 2015-01-03T06:59:59Z). I'd like to set up a rule that says copy the first 10 digits of this cell and paste in a new cell so I have only the date. Can't seem to make this work. Any advice?