Stardraw Forums

Cable Label Report/Edit Attributes Tool Problem

http://forums.stardraw.com/Topic6945.aspx

By timhabedank - 6/8/2011 1:12:50 PM

Hello,



I use a custom report to extract the Start and End labels to be used for printing off cable labels, and this works well. However, when I use the Edit Attributes tool to sequentially number the cables, the Excel report populates the cells with a value that isn't what I need. Example, in Excel, I see my labels A-101, A-102, etc. but when I select the cell, the value in the cell is 1, 2, etc.



How can I convert this custom number in Excel to text?



Thanks
By Rob Robinson - 6/8/2011 1:31:10 PM

Yes, that's correct: the value might be "1" but the number formatting displays this value as "A-101".

To convert the formatted number into a string that contains the formatting simply save your spreadsheet as a .txt file, close it and reopen the text file.  You will see the value is now "A-101".