Custom Format

%3CLINGO-SUB%20id%3D%22lingo-sub-2688000%22%20slang%3D%22en-US%22%3ECustom%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2688000%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20ID%20numbers%20that%20I'd%20like%20to%20custom%20format%20into%20emails%20addresses%2C%20adding%26nbsp%3B%40dallastown.net%20to%20each%20number.%26nbsp%3B%20Can%20I%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2688000%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2688073%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2688073%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1138420%22%20target%3D%22_blank%22%3E%40MistyWilson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20only%20need%20to%20display%20them%20as%20email%20addresses%2C%20or%20do%20you%20need%20them%20to%20act%20as%20clickable%20hyperlinks%3F%3C%2FP%3E%0A%3CP%3EIf%20the%20former%2C%20and%20if%20they%20contain%20only%20digits%2C%20you%20can%20do%20the%20following%3A%3C%2FP%3E%0A%3CP%3ESelect%20the%20IDs.%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2B1%2C%20then%20activate%20the%20Number%20tab%20of%20the%20Format%20Cells%20dialog.%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20custom%20format%20in%20the%20Type%20box%2C%20then%20click%20OK%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E0%22%40dallastown.net%22%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20IDs%20are%20text%20values%2C%20for%20example%20because%20they%20also%20contain%20letters%2C%20use%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%40%22%40dallastown.net%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a column of ID numbers that I'd like to custom format into emails addresses, adding @dallastown.net to each number.  Can I do that?

1 Reply

@MistyWilson 

Do you only need to display them as email addresses, or do you need them to act as clickable hyperlinks?

If the former, and if they contain only digits, you can do the following:

Select the IDs.

Press Ctrl+1, then activate the Number tab of the Format Cells dialog.

Enter the following custom format in the Type box, then click OK:

 

0"@dallastown.net"

 

If the IDs are text values, for example because they also contain letters, use

 

@"@dallastown.net"