View Single Post
  #4 (permalink)  
Old November 15th, 2006, 05:36 PM
peace95 peace95 is offline
Friend of Wrox
 
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

RichHartmann:

It is not clear whether the cusips already exist in an excel speadsheet or you want to move them from a database or file into an excel spreadsheet. In Excel 2003, using double-quotes("cusips") will leave the double-quotes around the number. However the single-quote just at the beginning of the cusip, converts the it to text and right-justify it and the single quote does not show. Could this be the case, if the cusips already exist in the XL-spreadsheet?