Question Locked
excel query
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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)