Jeffery,
Thanks for the quick reply. It's very much appreciated!
Yup, after clearing up a couple of syntax problems ToString("#.##") did
indeed work.
I wrote a quick test program to play with a few of the more common
iterations I'll need eventually ... I've included the Form1.cs in the
message body because of all the problems with attachments these days. I
hope this atones for my somewhat premature post to the group. :-}
B.T.W. I would love to see more examples of the 'fundamental' use of various
Ms Functions in future Ms documentation. Many of the examples in the
current Ms documentation don't seem to address the most fundamental / basic
use making it very difficult to get 'a quick idea' of how a function or
control can be put quickly into play.
Thanks again ...
Barry
in Oregon
================= Test ToString Numeric formatting =====================
using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Data.OleDb;
using System.Text;
using System.Windows.Forms;
namespace WindowsApplication1
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Label lblFormattedNbr1_2;
private System.Windows.Forms.Label lblFormattedNbr1_1;
private System.Windows.Forms.Label lblFormattedNbr2_2;
private System.Windows.Forms.Label lblFormattedNbr2_1;
private System.Windows.Forms.Label lblFormattedNbr4_2;
private System.Windows.Forms.Label lblFormattedNbr4_1;
private System.Windows.Forms.Label lblFormattedNbr3_2;
private System.Windows.Forms.Label lblFormattedNbr3_1;
private System.Windows.Forms.Label lblFormattedNbr5_2;
private System.Windows.Forms.Label lblFormattedNbr5_1;
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null;
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.label8 = new System.Windows.Forms.Label();
this.panel1 = new System.Windows.Forms.Panel();
this.lblFormattedNbr5_2 = new System.Windows.Forms.Label();
this.lblFormattedNbr5_1 = new System.Windows.Forms.Label();
this.lblFormattedNbr3_2 = new System.Windows.Forms.Label();
this.lblFormattedNbr3_1 = new System.Windows.Forms.Label();
this.lblFormattedNbr4_2 = new System.Windows.Forms.Label();
this.lblFormattedNbr4_1 = new System.Windows.Forms.Label();
this.lblFormattedNbr2_2 = new System.Windows.Forms.Label();
this.lblFormattedNbr2_1 = new System.Windows.Forms.Label();
this.lblFormattedNbr1_2 = new System.Windows.Forms.Label();
this.lblFormattedNbr1_1 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.textBox1 = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.panel1.SuspendLayout();
this.SuspendLayout();
//
// label8
//
this.label8.Location = new System.Drawing.Point(6, 10);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(592, 23);
this.label8.TabIndex = 22;
this.label8.Text = "Instructions:";
this.label8.TextAlign =
System.Drawing.ContentAlignment.MiddleLeft;
//
// panel1
//
this.panel1.BorderStyle =
System.Windows.Forms.BorderStyle.FixedSingle;
this.panel1.Controls.Add(this.lblFormattedNbr5_2);
this.panel1.Controls.Add(this.lblFormattedNbr5_1);
this.panel1.Controls.Add(this.lblFormattedNbr3_2);
this.panel1.Controls.Add(this.lblFormattedNbr3_1);
this.panel1.Controls.Add(this.lblFormattedNbr4_2);
this.panel1.Controls.Add(this.lblFormattedNbr4_1);
this.panel1.Controls.Add(this.lblFormattedNbr2_2);
this.panel1.Controls.Add(this.lblFormattedNbr2_1);
this.panel1.Controls.Add(this.lblFormattedNbr1_2);
this.panel1.Controls.Add(this.lblFormattedNbr1_1);
this.panel1.Controls.Add(this.button1);
this.panel1.Controls.Add(this.textBox1);
this.panel1.Controls.Add(this.label1);
this.panel1.Location = new System.Drawing.Point(4, 40);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(594, 338);
this.panel1.TabIndex = 21;
//
// lblFormattedNbr5_2
//
this.lblFormattedNbr5_2.BorderStyle =
System.Windows.Forms.BorderStyle.FixedSingle;
this.lblFormattedNbr5_2.Location = new System.Drawing.Point(224,
186);
this.lblFormattedNbr5_2.Name = "lblFormattedNbr5_2";
this.lblFormattedNbr5_2.Size = new System.Drawing.Size(100, 21);
this.lblFormattedNbr5_2.TabIndex = 12;
this.lblFormattedNbr5_2.TextAlign =
System.Drawing.ContentAlignment.MiddleCenter;
//
// lblFormattedNbr5_1
//
this.lblFormattedNbr5_1.Location = new System.Drawing.Point(26,
186);
this.lblFormattedNbr5_1.Name = "lblFormattedNbr5_1";
this.lblFormattedNbr5_1.Size = new System.Drawing.Size(194, 21);
this.lblFormattedNbr5_1.TabIndex = 11;
this.lblFormattedNbr5_1.TextAlign =
System.Drawing.ContentAlignment.MiddleLeft;
//
// lblFormattedNbr3_2
//
this.lblFormattedNbr3_2.BorderStyle =
System.Windows.Forms.BorderStyle.FixedSingle;
this.lblFormattedNbr3_2.Location = new System.Drawing.Point(224,
134);
this.lblFormattedNbr3_2.Name = "lblFormattedNbr3_2";
this.lblFormattedNbr3_2.Size = new System.Drawing.Size(100, 21);
this.lblFormattedNbr3_2.TabIndex = 10;
this.lblFormattedNbr3_2.TextAlign =
System.Drawing.ContentAlignment.MiddleCenter;
//
// lblFormattedNbr3_1
//
this.lblFormattedNbr3_1.Location = new System.Drawing.Point(26,
134);
this.lblFormattedNbr3_1.Name = "lblFormattedNbr3_1";
this.lblFormattedNbr3_1.Size = new System.Drawing.Size(194, 21);
this.lblFormattedNbr3_1.TabIndex = 9;
this.lblFormattedNbr3_1.TextAlign =
System.Drawing.ContentAlignment.MiddleLeft;
//
// lblFormattedNbr4_2
//
this.lblFormattedNbr4_2.BorderStyle =
System.Windows.Forms.BorderStyle.FixedSingle;
this.lblFormattedNbr4_2.Location = new System.Drawing.Point(224,
160);
this.lblFormattedNbr4_2.Name = "lblFormattedNbr4_2";
this.lblFormattedNbr4_2.Size = new System.Drawing.Size(100, 21);
this.lblFormattedNbr4_2.TabIndex = 8;
this.lblFormattedNbr4_2.TextAlign =
System.Drawing.ContentAlignment.MiddleCenter;
//
// lblFormattedNbr4_1
//
this.lblFormattedNbr4_1.Location = new System.Drawing.Point(26,
160);
this.lblFormattedNbr4_1.Name = "lblFormattedNbr4_1";
this.lblFormattedNbr4_1.Size = new System.Drawing.Size(194, 21);
this.lblFormattedNbr4_1.TabIndex = 7;
this.lblFormattedNbr4_1.TextAlign =
System.Drawing.ContentAlignment.MiddleLeft;
//
// lblFormattedNbr2_2
//
this.lblFormattedNbr2_2.BorderStyle =
System.Windows.Forms.BorderStyle.FixedSingle;
this.lblFormattedNbr2_2.Location = new System.Drawing.Point(224,
108);
this.lblFormattedNbr2_2.Name = "lblFormattedNbr2_2";
this.lblFormattedNbr2_2.Size = new System.Drawing.Size(100, 21);
this.lblFormattedNbr2_2.TabIndex = 6;
this.lblFormattedNbr2_2.TextAlign =
System.Drawing.ContentAlignment.MiddleCenter;
//
// lblFormattedNbr2_1
//
this.lblFormattedNbr2_1.Location = new System.Drawing.Point(26,
108);
this.lblFormattedNbr2_1.Name = "lblFormattedNbr2_1";
this.lblFormattedNbr2_1.Size = new System.Drawing.Size(194, 21);
this.lblFormattedNbr2_1.TabIndex = 5;
this.lblFormattedNbr2_1.TextAlign =
System.Drawing.ContentAlignment.MiddleLeft;
//
// lblFormattedNbr1_2
//
this.lblFormattedNbr1_2.BorderStyle =
System.Windows.Forms.BorderStyle.FixedSingle;
this.lblFormattedNbr1_2.Location = new System.Drawing.Point(224,
82);
this.lblFormattedNbr1_2.Name = "lblFormattedNbr1_2";
this.lblFormattedNbr1_2.Size = new System.Drawing.Size(100, 21);
this.lblFormattedNbr1_2.TabIndex = 4;
this.lblFormattedNbr1_2.TextAlign =
System.Drawing.ContentAlignment.MiddleCenter;
//
// lblFormattedNbr1_1
//
this.lblFormattedNbr1_1.Location = new System.Drawing.Point(26,
82);
this.lblFormattedNbr1_1.Name = "lblFormattedNbr1_1";
this.lblFormattedNbr1_1.Size = new System.Drawing.Size(194, 21);
this.lblFormattedNbr1_1.TabIndex = 3;
this.lblFormattedNbr1_1.TextAlign =
System.Drawing.ContentAlignment.MiddleLeft;
//
// button1
//
this.button1.Location = new System.Drawing.Point(224, 38);
this.button1.Name = "button1";
this.button1.TabIndex = 2;
this.button1.Text = "Format Nbr";
this.button1.Click += new
System.EventHandler(this.button1_Click);
//
// textBox1
//
this.textBox1.AutoSize = false;
this.textBox1.Location = new System.Drawing.Point(116, 38);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(100, 21);
this.textBox1.TabIndex = 1;
this.textBox1.Text = "";
//
// label1
//
this.label1.Location = new System.Drawing.Point(26, 38);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(84, 21);
this.label1.TabIndex = 0;
this.label1.Text = "Enter Number:";
this.label1.TextAlign =
System.Drawing.ContentAlignment.MiddleLeft;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(604, 383);
this.Controls.Add(this.label8);
this.Controls.Add(this.panel1);
this.Name = "Form1";
this.StartPosition =
System.Windows.Forms.FormStartPosition.CenterScree n;
this.Text = "Form1";
this.panel1.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void button1_Click(object sender, System.EventArgs e)
{
decimal nTestNbr = 0;
try
{
nTestNbr = decimal.Parse(this.textBox1.Text);
lblFormattedNbr1_1.Text = "ToString('#.##')";
lblFormattedNbr1_2.Text = nTestNbr.ToString("#.##");
lblFormattedNbr2_1.Text = "ToString('00.00')";
lblFormattedNbr2_2.Text = nTestNbr.ToString("00.00");
lblFormattedNbr3_1.Text = "ToString('#,#')";
lblFormattedNbr3_2.Text = nTestNbr.ToString("#,#");
lblFormattedNbr4_1.Text = "ToString('##-##-##')";
lblFormattedNbr4_2.Text = nTestNbr.ToString("##-##-##");
lblFormattedNbr5_1.Text = "ToString('(###)###-####')";
lblFormattedNbr5_2.Text =
nTestNbr.ToString("(###)###-####");
}
catch
{
MessageBox.Show("Invalid Number entered.\nPlease try
again\n\n");
}
}
}
}
================================================== ============
""Jeffrey Tan[MSFT]"" <v-*****@online.microsoft.com> wrote in message
news:WW*************@cpmsftngxa06.phx.gbl...
Hi BBFrost,
Based on my understanding, you want to do the custom formatting for your
Numeric value.
I see that you have already found the answer to your question.
ToString("#.##") should work for you.
I think you may need a general specification of the numeric formatting.
Actually, in Numeric Format String, "#" is a digit placeholder, while "."
is a Decimal point.
For more information, please refer to:
"Custom Numeric Format Strings"
http://msdn.microsoft.com/library/de...us/cpguide/htm l/cpconcustomnumericformatstrings.asp
Also, there some samples may help you:
"Custom Numeric Format Strings Output Examples"
http://msdn.microsoft.com/library/de...us/cpguide/htm l/cpconcustomnumericformatstringsoutputexample.asp
=====================================
Please apply my suggestion above and let me know if it meets your need.
Thank you for your patience and cooperation. If you have any questions or
concerns, please feel free to post it in the group. I am standing by to be
of assistance.
Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.