Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Currency Field Problem
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00860427
Message ID:
01127120
Views:
15
>Try something similar to this:
>
>* suppress zeros, format as currency, for negative numbers use () and red color
>.columns("J:K").NumberFormat ="$#,##0.00_);[Red]($#,##0.00);;@"
>
>
Thanks, Yuri.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform