Cell Format

  • Thread starter Thread starter Mark
  • Start date Start date
M

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?
 
As I think has been said before, you'd have to use Event macros to
change the formatting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Format 3
Time punch data from rows to columns 3
format social security number 2
Converting a date to a text field w/o converting it to a julian da 2
Help.... on mail label 1
Repeated data into flat file format 4
How to turn off the automatic date feature in Excel 2003 8
Conditional Formatting from a group 6

Back
Top