Problem removing 0

[jermsalerms]

Helper Sheet AQ2:AQ901 contain phone numbers

some have been entered 0 when there is no number provided. I am tryin
to write a formula that will state if AQ2 = 0 then field is blank.

in cell V2 I have tried to write all the following formulas and al
result with the 0 still remaining

=IF(ISNUMBER('Helper Sheet'!AQ2)="0","",IF('Helpe
Sheet'!AQ2="","",'Helper Sheet'!AQ2))

=IF(ISTEXT('Helper Sheet'!AQ2)="0","",IF('Helpe
Sheet'!AQ2="","",'Helper Sheet'!AQ2))

=IF('Helper Sheet'!AQ2="0","",IF('Helper Sheet'!AQ2="","",'Helpe
Sheet'!AQ2))


any other suggestion

 

[Guest]

Try =IF('Helper Sheet'!AQ2=0,"",'Helper Sheet'!AQ2). HTH

Sincerely, Michael Colvin

 

[PCLIVE]

It seems like this should work.

=IF(OR('Helper Sheet'!AQ2="0",'Helper Sheet'!AQ2="",'Helper
Sheet'!AQ2=0),"",'Helper Sheet'!AQ2)



"jermsalerms" <[email protected]>
wrote in message
news:[email protected]...

 

[Dave Peterson]

=if('helper sheet'!aq2=0,"",'helper sheet'!aq2)

maybe????

 

[Guest]

If you want the zero to appear blank, then select the cell and pull-down:

Format > Cell > Number > Custom and enter #,### in place of general

 

[jermsalerms]

I tried PCLIVE's and it worked so Im sticking with it