Importing Excel to Numbers

Levelonion wrote:

Why was it okay in the past and is now all messed up and what can I do about it??

I have no idea why it worked in the past but not now. You should consider giving feedback to Apple via Numbers > Provide Numbers Feedback in your menu.

But here's one thing you can do about it. Select the cells where the dates show as numbers and run the script below. This requires no knowledge of AppleScript, just how to copy-paste, select and click.

set startdate to date "Monday, January 1, 1900 at 12:00:00 AM"

tell application "Numbers" to tell front document
	tell active sheet
		tell (first table whose class of selection range is range)
			repeat with c in (get selection range)'s cells
				set value of c to startdate + ((value of c) - 2) * days
			end repeat
		end tell
	end tell
end tell

1. Copy-paste the script into Script Editor (in Applications > Utilities)
2. The first time, make sure Script Editor is listed and checked at System Preferences > Security & Privacy > Privacy > Accessibility.
3. Select the cells where the dates now appear as numbers.
4. Click the <run> button in Script Editor.

That's it! It takes less than a minute.

Save the script for use the next time. You could even place it in the script menu.

Then it will take just a few seconds.

SG