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.