I have 4 columns with a three digit number in each. all start with 0 so they are formated as text.
I need them to end up looking like 000-000-000-000. when I tryall of the zeros go away.![]()
=A2&-B2&-C2&-D2
how can I do this.
I have 4 columns with a three digit number in each. all start with 0 so they are formated as text.
I need them to end up looking like 000-000-000-000. when I tryall of the zeros go away.![]()
=A2&-B2&-C2&-D2
how can I do this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks