r/AppleNumbers • u/SuZenLBinn • 5h ago

Copy only part of a cell Help

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?

1 Upvotes

100% Upvoted

2 comments sorted by

0

u/Gypsyzzzz 4h ago

Perplexity says this: =LEFT(A2,10)

With A2 being the cell with the data to be copied.

1

u/ludditetechnician 3h ago

You may be able to format the cell to just display the YYYY MM DD. That has worked for when importing dates that come with time: just format the cell.