Convert number to date

I have a Numbers spreadsheet in which one column comprises 5-digit integers such as 42849. I know that these are derived from an excel file in which they were dates. How can I convert them back to dates in Numbers?

MacBook Pro 13″, macOS 13.4

Posted on Jul 2, 2024 6:27 AM

Similar questions

Numbers: Convert CSV text dates for sorting I have a csv file that I've opened in Number and I want to sort the date column by date (obviously). But when I run a sort, it sorts "1 April, 1 August, 1 Dec, 1 July, 2 April, 2 August," and so on. Clearly the date is being treated as text, so how do I convert it to a date format? I tried converting it to xlsx file and opening it wiht LibreOffice and get "Ranges containing merged cells can only be sorted without formats". I'm sure this is really simple, but I can't find a reply... Thanks!
256 3
Numbers date formatting question What is the difference in date format in these examples ? My cells in Numbers exhibit different formats - how do I convert them to the same format ?
921 11
Numbers Date Conversion 20XX instead of 19XX Hi community When I import dates such as 7/14/71 and try to convert them to show the full year (looking for 07/14/2071) it converts to 07/14/1971 Is there a way to set it so that it automatically converts to 20XX instead of 19XX? I would update the cells manually but 500+ cells need to be formatted This happened in Excel and Google Sheets as well but I can not seem to find a solution Any ideas on what settings I need to change in order to make this happen?
776 2

1 reply

Badunit

Level 7

31,509 points

Jul 2, 2024 8:53 AM in response to jgc1948

converting Excel date numbers to dates - Apple Community

SGIII's script in that thread is probably the better one to use if you want to use a script instead of formulas.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Convert number to date

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up