Do you know if you can force a specific formatting for a column? What I want
to do is, I have a column with a MAC Address that looks like this:
005004a1b4a9 and I would really like to reformat it to something like this:
00-50-04-a1-b4-a9. Is there a way to do this automatically with the columns
already populated?

Thanks in advance!

Number formatting will work with numbers--not text.

But you could insert a helper column and make it look like you want:

=if(a1="","",mid(a1,1,2)&"-"&mid(a1,3,2)&"-"&mid(a1,5,2)&"-"&mid(a1,7,2)& ...

(I got tired! Just continue until you're out of letters <vbg.)

PattiTechWriter wrote:

Do you know if you can force a specific formatting for a column? What I want
to do is, I have a column with a MAC Address that looks like this:
005004a1b4a9 and I would really like to reformat it to something like this:
00-50-04-a1-b4-a9. Is there a way to do this automatically with the columns
already populated?

Thanks in advance!

--

Dave Peterson

Thanks Dave! Saved me alot of time!!

"Dave Peterson" wrote:

Number formatting will work with numbers--not text.

But you could insert a helper column and make it look like you want:

=if(a1="","",mid(a1,1,2)&"-"&mid(a1,3,2)&"-"&mid(a1,5,2)&"-"&mid(a1,7,2)& ...

(I got tired! Just continue until you're out of letters <vbg.)

PattiTechWriter wrote:

Do you know if you can force a specific formatting for a column? What I want
to do is, I have a column with a MAC Address that looks like this:
005004a1b4a9 and I would really like to reformat it to something like this:
00-50-04-a1-b4-a9. Is there a way to do this automatically with the columns
already populated?

Thanks in advance!

--

Dave Peterson