NumberFormat syntax tutorial

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin Burton - 31 May 2008 09:21 GMT

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.

Reply to this Message

keepITcool - 31 May 2008 10:46 GMT

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

> 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
[quoted text clipped - 5 lines]
>
> Thank you.

Reply to this Message

Gord Dibben - 31 May 2008 16:12 GMT

Check out John Walkenbach's site for a workbook download.

http://www.j-walk.com/ss/excel/tips/tip19.htm

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 4 lines]
>
>Thank you.

Reply to this Message