Great blog post!
I studying math this year and need to use excel. Do you know how to edit format of cells with AppleScript? e.g fraction, decimal number etc. Have Keyboard Maestro.
I know that I can press ⌘ + 1 to jump to cell menu, but this tab is clunky with VoiceOver. Therefore would like to avoid that menu to reduce frustration
I might have just found my “warm up for the day” exercise. I have my own reasons for wanting to manipulate the format…
… Excel seems to insist that date-like cells are dates. And then does strange things with the x axis of a chart. So I want to
Fiddle with the text to remove the year.
Force the cell to Text.
I’d want to do that for a whole column but - along the way - I’d want to transform a single cell in the above two ways. Each of those two ways might be something people can build on.
Note: I want to do this in AppleScript. Not keypresses.