http://forums.method.me/cs/forums/26.aspxAsk technical support questions, how do I?...or anything else you want to know from the Method Team.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/26833.aspxWed, 22 Apr 2015 17:40:07 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:26833Method_Audisho0http://forums.method.me/cs/forums/thread/26833.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=26&PostID=26833<p class="p1">Hi joshsAA,</p> <p class="p1">Labels and text objects do not allow you to format the contained value in this manner. Most of the objects with dollar amounts on our screens are <i>money</i> fields that are stored in the table. These fields are formatted to 2 decimal places by default.</p> <p class="p1">If you are using a <i>basic math calcu<span id="mce_9_start" style="overflow:hidden;"></span>lation </i>action to obtain your daily sales value, the action allows you to specify the number of decimal places to round the result to. If you&rsquo;re not already using a <i>basic math calculation</i> you can use one for just rounding your resu<span id="mce_1_start" style="overflow:hidden;"></span>lt:&nbsp;Add 0 and round to 2 decimal places.</p> <p class="p1">As for display<span id="mce_4_start" style="overflow:hidden;"><span id="mce_5_start" style="overflow:hidden;"><span id="mce_6_start" style="overflow:hidden;"><span id="mce_7_start" style="overflow:hidden;"><span id="mce_8_start" style="overflow:hidden;"></span></span></span></span></span>ing a dollar sign, just add another label to the left and set the caption to &ldquo;$&rdquo;. I hope this helps.</p> <p class="p1">-Audisho<span id="mce_3_start" style="overflow:hidden;"><span id="mce_4_end" style="overflow:hidden;"><span id="mce_5_end" style="overflow:hidden;"><span id="mce_6_end" style="overflow:hidden;"><span id="mce_7_end" style="overflow:hidden;"><span id="mce_8_end" style="overflow:hidden;"></span></span></span></span></span></span></p>http://forums.method.me/cs/forums/thread/26832.aspxWed, 22 Apr 2015 17:13:48 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:26832joshsAA0http://forums.method.me/cs/forums/thread/26832.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=26&PostID=26832<p>How can I format a number that is in a label found on a screen, NOT in a report.<span style="overflow:hidden;" id="mce_0_start">?</span>&nbsp; I have a label that contains daily sales, but looks like 2840.2300 and I would like it to look like $2,840.23.<span style="overflow:hidden;" id="mce_1_start"></span><span style="overflow:hidden;" id="mce_2_start"></span></p>