Kevin,

i suggest you try google ;-)

look what i found:
http://www.ozgrid.com/Excel/CustomFormats.htm

looks like a good page to read.
note however that it's mostly the numberformats as used in excel cells.

this is the programming group, and various VBA functions
use numberformats as well, but the syntax varies a bit.

also search excel help.
it's not very accessible, but it does contain a wealth of information.
same goes for VBA help.

else buy yourself a good excel book, which should be a good investment.

cheerz!
keepITcool

--



Kevin Burton wrote:

I was looking for a tutorial on the syntax of NumberFormat. I have
been able to glean from various posts formats like "m/d/yyy" and
"#.00". But, There are certainly more complex formats available (and
probably simpler ones). I look at the documentation for the
NumberFormat poperty and it just states "see Cells.NumberFormat".
Which when I look it doesn't seem to give a definitive guide to the
syntax either. Any pointers?

Thank you.