| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error in this code | Excel Worksheet Functions | |||
| Error in my code? | Excel Programming | |||
| How can I still go to the error-code after a On Error Goto? | Excel Programming | |||
| Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
| Error in Code | Excel Programming | |||
![Stuart[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
