View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Format a number field as text


"@" 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)