Adding additional number formats

[donal.conlon]

Hi

How do I go about adding an additional number format (preferrably not
through code). For example, I want:

I want negative values to show in brackets not with a -; like currency
type, but without the current symbol.

or be able to round up/down a currency value?

cheers for any guidance.

 

[Alvin Bruney - MVP ASP.NET]

sorry to disappoint but this is already part of the OWC.
you would need to do something like .numberformat = ";;[#.##]". This is off
the top of my head so I don't expect it to work but this is the general
idea. For the full implementation, see the black book.

To do that without code, you may have to do it in a macro - which is still
code. I guess you can examine the number format property in the designer - i
do believe it is customizable.
--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

 

[donal.conlon]

Thanks Alvin,

I have your book and hoping to get time to read it! We are using BIP
here, so I dont suppose you'd know where i'd look to add this
functionality?

Cheers

 

[Alvin Bruney - ASP.NET MVP]

p471 if I recall correctly

nope, my memory aint that good. I looked it up lastnight while stealing
material for my new book

--
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