Thread: BLANK SPACE TO A NUMBER
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default BLANK SPACE TO A NUMBER

Try,

=IF(ISBLANK(B12),0)

This creates a circular reference. You will get a pop up. Just click
on Cancel to allow the formula as is. Copy this to the cells you want
to apply to.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=496984

Reply With QuoteReply With Quote