View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pajones via OfficeKB.com pajones via OfficeKB.com is offline
external usenet poster
 
Posts: 4
Default How to have a cell show as blank

Perfect - that worked. Thanks for the quick response!
Phil

PCLIVE wrote:
Try something like:
=If(A1="","",A1)

Hi - wondering if someone can point me in the right direction. I have a
spreadsheet that is being used as an order form and contains both numbers

[quoted text clipped - 23 lines]

Thx, Phil


--
Message posted via http://www.officekb.com