|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 5th, 2005, 09:49 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom formatting??
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! 
|
|
#2
December 5th, 2005, 10:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
custom formatting??
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
|
|
#3
December 5th, 2005, 10:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
custom formatting??
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Custom charts - default formatting | tomjohns | Charts and Charting | 2 | September 19th, 2005 01:34 PM |
| Required Field Conditional | Katherine R | New Users | 2 | September 1st, 2004 05:52 AM |
| Excel Question On Custom Formatting the cells | excelnaive | Worksheet Functions | 6 | April 20th, 2004 07:42 PM |
| Custom Number Formatting | Worksheet Functions | 0 | January 9th, 2004 03:30 PM | |
| custom formatting cells | lisa & corinne | Worksheet Functions | 2 | December 9th, 2003 08:15 PM |
Linear Mode
