Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Format mask for numbers
Message
 
To
08/12/2008 22:51:36
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Re: Format mask for numbers
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01365281
Message ID:
01366177
Views:
18
>That would solve a part of the problem.
>However, it there any way to put in the comma formats for numbers as well?
>Yau

TRANSFORM(YourNumber, ICASE(FirstCondition=.t., '999.999', SecondCondition=.t., '9,999.99', ThirdCondition=.t., '99,999.9', '999,999'))
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Reply
Map
View

Click here to load this message in the networking platform