Leading zeros lost from teradata when copied into excel

Question

So my cast function here puts leading zeros on my column called ndc11…however (which is great because I need it to be 11 digits), when I copy and paste it into excel, it looses the leading zeros. Any way to turn this also into TEXT format so that it doesn’t lose the formatting in excel?

select extract(month from pf.fill_sold_dt ), Cast((Cast(ndc11 As Integer) (Format '9(11)')) As varChar(11) )    , generic_prod_id,prod_name, drug_type_cd, sum(fill_qty_dspn) as Pills,  sum((fill_qty_dspn)/(pkg_sz*pkg_qty) )as Packs
from 
        prdedwvwh.prescription_fill_sold pf 
inner join 
        prdedwvwh.drug_cur d
on
        pf.drug_id = d.drug_id
where 
fill_sold_dt between '2014-05-01' and '2015-04-30' and 
generic_prod_id in ( '62100005008540','62100005008530','62100005008520')

group by 1,2,3,4,5

Answer 1

Format the column as Text before the data goes in and then Paste Special -> Values

Answer 2

You don't need to store those values as text (thereby losing ability to operate with them). Use a Custom format, with 11 zeroes, see this.

1. On the Format menu, click Cells.
2. Click the Number tab.
3. Click Custom.
4. In the Type box, type the custom format.
5. Click OK.

Answer 3

Concatenate a single apostrophe ' at the start of the 11-digit number. Excel will then treat it as text.