Hi,

Just for the record; here are two good sources:
http://www.mvps.org/dmcritchie/excel....htm#getformat
http://support.microsoft.com/?scid=k...d=1743&sid=340

And examples how to use it:
# # : 1 000 000 (#blank#)
# # ' : 1 000' (#blank#blank')
# '' : 1'' (#blankblank'') that is two '
+
#.### ' : 1.000'

Ola