Cell Format

[Steve]

This could be confusing, but i will give it a try.

On one work sheet you can enter either a social security
number or a federal tax id number. These numbers will be
transfered to anoter work sheet. Social is entered as
XXX-XX-XXXX and FEIN as XX-XXXXXXX. I want them to
transfer to the other worksheet in the same format. Is
that possible. If you format the cell that the numbers
are being transfered to, you can only format it as a
social or FEIN.

 

[JE McGimpsey]

If the original cells are preformatted as Text (which they should be -
you don't do math on SSN's or FEINs), then using

=Sheet1!A1

will return the exact string that was entered.

 

[Steve]

Unfortunately it still does not work. I forgot to
mention something, (probably the most important thing)

Within the form there is a check box indicating if they
are entering a social or FEIN. If the check box for
social says true, then you put the social, however if the
check box for FEIN is true, then you put the FEIN. Here
is the formula that i have.

=IF(FRM!AG49=TRUE,FRM!AF51,IF(FRM!AG50=TRUE,FRM!
AF52,"")))

 

[Frank Kabel]

Hi
then you're probably out of luck. Formulas can't change formats