Thread: Blanks treated as zeroes in a numeric field
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default Blanks treated as zeroes in a numeric field
You can do something like this

=if(isblank(A1),na(),a1)

--
HTH,
Barb Reinhardt



"Bob Aloisi" wrote:

How can I stop Excel from treating blanks as zeroes in a numeric field?
Reply With QuoteReply With Quote