Hi,
A bit new to Applescipts and struggling with this one.
I am trying to change a column in Excel that is showing as ‘scientific notation’, actually a EAN barcode.
Needs to be shown as whole numbers then file saved as ‘windows CVS’ to upload to a website.
Can get some scripts to work like save and close but not the format change.
Tried this and don’t get errors but it does not change data in worksheet -
tell application "Microsoft Excel"
tell sheet 1
tell column 11
set data type of column 1 of active sheet to number
set NumberFormat of column 11 to whole
end tell
end tell
end tell
If anyone can help it would be brilliant…
Thanks