<div>
&lt;CFSET MyNumber = &quot;128.56&quot;&gt;<br />
&lt;CFOUTPUT&gt;#NumberFormat(My<wbr />Number*100<wbr />, 000000)#&lt;/CFOUTPUT&gt;<br />
<br />
HTH,<br />
<br />
-Dain
</div>


<CFSET MyNumber = "128.56">
<CFOUTPUT>#NumberFormat(MyNumber*100, 000000)#</CFOUTPUT>

HTH,

-Dain

<div>
Great but one question...<br />
<br />
<br />
I was using this:<br />
#NumberFormat(MyNumber, 9999.99)#<br />
<br />
If a value (MyNumber) was null, it would get 0.00 automatically. &nbsp;How can I write your solution so that remains true? <br />
<br />
Otherwise, I get an error on null values saying: &quot;&quot;&nbsp;Cannot be converted to a number.<br />
<br />
I don't want to hard code a bunch of &lt;cfif's in my code.
</div>


Great but one question...


I was using this:
#NumberFormat(MyNumber, 9999.99)#

If a value (MyNumber) was null, it would get 0.00 automatically.  How can I write your solution so that remains true?

Otherwise, I get an error on null values saying: "" Cannot be converted to a number.

I don't want to hard code a bunch of <cfif's in my code.

<div>
I would just add a VAL() function, which translates to 0 for nulls.<br />
<br />
#NumberFormat(VAL(MyNumber<wbr />)*100, 000000)#<br />
<br />

</div>


I would just add a VAL() function, which translates to 0 for nulls.

#NumberFormat(VAL(MyNumber)*100, 000000)#



<div>
<div class="content wysiwyg-content">
I have a dollar amount: 128.56<br />
<br />
I need to make it into a 6 byte field, left padded with zeros and the decimal removed (decimal implied) for a delimited flat file.<br />
<br />
Taget format: &nbsp;012856
</div>
</div>


I have a dollar amount: 128.56

I need to make it into a 6 byte field, left padded with zeros and the decimal removed (decimal implied) for a delimited flat file.

Taget format:  012856

Number format: Left pad and remove decimal

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.