In order to make the numbers have a fixed number of decimal places I could insert code similar to the following in each of the Case statements of that button script to get the format I want:
Code: Select all
...
set the numberFormat to "#.00" -- or #.0000 as the case requires
put pData * 1 into pData
...
A second question goes back even further. Since I have at least 10 columns that require special formatting, is the switch - case technique in the single button 'My Default Column Behavior' as efficient as having individual scripts (buttons) that the Column Inspector would give.
Finally, I have been avoiding any type of currency formatting in the columns because I need to add them up. I would prefer to have that formatting in US currency however if there is a good way to handle it. Any suggestions?
Regards and thanks,
Larry