Thread: changing the zero from a cell to an "X" instead of a zero
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default changing the zero from a cell to an "X" instead of a zero
Welcome. Please start new threads for new queries. And do hit the YES button
in the earlier response which worked for you.
--
Max
Singapore
---
"Champ" wrote:
This did work, thank you so much for the help.
=IF(AR8="","",AR8)

Do you want to try this as well or should I begin a new thread?

Reply With QuoteReply With Quote