excel query

Hi all-I had this issue arise today

In new cell type a formula that multiples your value by 1: =A12*1
Insert a new column and Edit>Paste special>Values
Insert a third column and convert to text (if necessary): =TEXT(C2,”000000″) the zeros signify the format and number of characters (you could also use MM/DD/YYYY or MM-DD-YY, or , etc)