On 3/14/01, Mak Wing Lok penned:
>sorry that i did not write the problem clearly, it supposed to display
>whatever number in 999,999,999,999,999,999.99 format as the variable "no"
>can contains any numeric value, but whenever no = 0, it will show as .00 not
>0.00, how could i format it so it display 0.00?
Try this:
#Trim(numberformat(num, '99999999999.00'))#
Put more 9s than the length of your number will ever be so you never
retrun an error. 0 will return 0.00, padded with spaces. Trim() will
get rid of the spaces.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
