NumberFormat syntax tutorial

  • Thread starter Thread starter Kevin Burton
  • Start date Start date
K

Kevin Burton

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.
 
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
 
Back
Top