Forum Discussion
Solved
Zip+4 not showing the dash
hello. I combined two columns using the =CONCAT function. The two columns were zip code and then the Plus 4 digits. I then highlighted the new column to change it to the Special Text Zip+4. However,...
That since CONCAT() returns text, not number, and you shall re-enter after changing the type.
You may change formula on O1 from =CONCAT(A1,B1) on =CONCAT(A1,B1)+0
Apply ZIP+4 format to column O, select entire range (e.g. O1:O1000) and Ctrl+D.
Alternatively use texts like =A1 & "-" & B1
Thanks Sergei. I will try what you suggested.
Thanks so much Sergie. It worked!
jackiebiggs , you are welcome, glad it helped