Code error
 

The following is copied from google, but errors in red when I paste it into
a module:

.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-
""??_);_(@_)"

Can you tell what it should be, please?

Regards

Code error
 

This worked for me

With Range("A1")
..NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""??_);_(@_)"
End With

make sure you correct any NG linewrap

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stuart" wrote in message
...
The following is copied from google, but errors in red when I paste it
into
a module:

.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-
""??_);_(@_)"

Can you tell what it should be, please?

Regards

Code error
 

Seems to do the trick.
Many thanks.

Regards.

"Bob Phillips" wrote in message
...
This worked for me

With Range("A1")
.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""??_);_(@_)"
End With

make sure you correct any NG linewrap

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stuart" wrote in message
...
The following is copied from google, but errors in red when I paste it
into
a module:

.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-
""??_);_(@_)"

Can you tell what it should be, please?

Regards