Excel 03:

Any ideas why some NumberFormat strings fail ?
e.g. "$"#,##0_);("$"#,##0)

Application.FindFormat.NumberFormat = strFormatString

Seems to error when a non-custom string is applied.

Found an old post from keepITcool to get the list of Built-in numberformats,
but prefer not to go that way.

'Newsgroups: microsoft.public.Excel.programming
'Date: Thu, 01 Jul 2004 16:21:46 -0700
'Local: Fri 2 Jul 2004 07:21
'Subject: Leo Heuser format cleanup code, and a question

NickHK