On Wed, 7 Jan 2009 13:55:37 -0800, TomP wrote:

I'll try to explain this a little better. The phone number format works
fine. The problem I'm having is with the ELSE Statement.

I would think that with the ELSE statement CPPHONE = "" would return a Null
value or an empty cell, but what I get are brackets, underscores and hyphen.
The cell reference is formatted to General text. All I would like to get is
an empty cell.


Thank you,

The solution I provided would not only give you the correct format, but would
also return nothing if CPPHONE = "".

I thought that was what you wanted.

It was an alternative since you have not told us what is contained in
ScreenTextB at the time you enter this IF statement.

Since the ELSE statement is not being executed, ScreenTextB must contain 12
characters at that time.
--ron