How do I script a Numbers table to accept 11/09/15 (a Finder sortable date) as text? Simply declaring it as text doesn’t cut it – Numbers transforms it into a screwed up date like November 9, 2015

tell application "Numbers"
	tell table 1 of sheet 1 of document 1
		set format of cell "A1" to text
		set value of cell "A1" to "11/09/15"
	end tell
end tell

adam, can’t you also simply change the format in numbers? i haven’t used numbers in a while, but last time i checked, you should be able to.

Thank you both – my problem is that I don’t know what you can do in Numbers because I haven’t used it much. Now I see that I could set the format of a range of cells and then add the data.