Non-Standard Number Formats

[Chris Kiklas]

Is it possible with OWC to add a number format? For example:

Standard format gives you 123,456.78
and
General format gives you 123456

What I would like to see is 123,456

but I can't find a pre-set format for this.

Can I add one somewhere?

Thanks in advance

 

[Alvin Bruney - ASP.NET MVP]

set your numberformat property = "###,###"
That will work.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/

 

[Chris Kiklas]

Hey Alvin,

This was actually great advice. The only other tweak I need to figure
out is how to get it to not round the totals.

Thanks for sending me on the right path!

-c.

 

[Alvin Bruney]

np

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006