"@" is the designator that tells Excel to format cells as text.
"General" is the default format.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"Tony Girgenti"
wrote in message
Hello Jim.
I'm not sure of what "@" is supposed to do, but that did not work.
Thanks,
Tony
"Jim Cone"
wrote in message
Tony,
Try changing "Text" to "@"...
newExcelWorkSheet.Columns("C").NumberFormat = "@"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)