With put '[format.number("#,##0")]'; I was expecting to have the value 12798 shown as 12 798. Instead I got 12798,0. (I'm living in Europe, I want an empty space between 2 and 7.)
If I do it manually in an Excel sheet and record a macro, then the macro text contains the format "#,##0".
And the alignment(4) didn't have any effect. I can't understand what's wrong!
Another problem: If I have transferred 0 (zero) to cells that I want empty( I have reasons to do like that) and then want blank signs in those cells I tried with
put '[select("r1c1:r1c5")]';
put ' ' ;
It didn't work. How can it be done?
In an another, earlier answer you had some code with "link command" twice, which was for starting Excel. It shouldn't be necessary to start Excel more than once, or have missed something fundamental?
Susan