PC Review


Reply
Thread Tools Rate Thread

FindFormat.NumberFormat fails with some strings

 
 
NickHK
Guest
Posts: n/a
 
      11th Jan 2008
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: Re: Leo Heuser format cleanup code, and a question

NickHK


 
Reply With Quote
 
 
 
 
Jim Rech
Guest
Posts: n/a
 
      11th Jan 2008
Might be the quotes aren't right. This works for me:

strFormatString = """$""#,##0_);(""$""#,##0)"

--
Jim
"NickHK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| 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: Re: Leo Heuser format cleanup code, and a question
|
| NickHK
|
|


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Strings Strings Strings from sql ds. =?Utf-8?B?Q2hyaXN0b3BoZXI=?= Microsoft C# .NET 5 10th Dec 2004 01:20 AM
Make Word displays strings of text, not strings of code =?Utf-8?B?WGVybw==?= Microsoft Word Document Management 2 9th Dec 2004 11:35 AM
Finding strings within strings =?Utf-8?B?Um9k?= Microsoft Excel Programming 1 2nd Dec 2003 06:34 PM
Finding strings within strings Rod Microsoft Excel Programming 1 2nd Dec 2003 06:19 PM
PN: Converting C Strings to managed strings Peter Nolan Microsoft VC .NET 0 21st Nov 2003 12:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:44 PM.