Cell Format

[Mark]

I asked this question before, but I am hoping that if i
ask it a different way, it might work.

Can a Cell have the capability of having two different
formats.

If you enter a social it will come up as XXX-XX-XXXX
If you enter a FEIN it will come up as XX-XXXXXXX

Can this be done?

 

[Chip Pearson]

Mark,

No, you can't have multiple formats for text in a cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[JE McGimpsey]

As I think has been said before, you'd have to use Event macros to
change the formatting.