Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format Excel through DTS script

Status
Not open for further replies.
IncredibleVolk

IncredibleVolk

Technical User
Apr 2, 2004
67
US
I currently use the following to change the number format in Excel:

oSheet.Range("H3", "H800").NumberFormat = "[BLACK]###,###;[RED](###,###)"


Is there a way to change the format to a phone number format or social security number format?
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Truncated Excel Fields
Replies
0
Views
196
grnzbra
grnzbra
Fsoumia
  • Locked
  • Question
DTS Logging
Replies
2
Views
172
Fsoumia
Fsoumia
WordTechinc
  • Locked
  • Question
DTS disable Daily Run 1
Replies
1
Views
90
drlex
drlex
Aluminum
  • Locked
  • Question
DTS Raiserror messages suddenly stopped displaying
Replies
0
Views
79
Aluminum
Aluminum
Azzuri
  • Locked
  • Question
DTS To SQL Server 2008
Replies
1
Views
111
mrdenny
mrdenny

Part and Inventory Search

Sponsor

Back
Top