View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
day[_2_] day[_2_] is offline
external usenet poster
 
Posts: 7
Default How to get rid of #Value!

I checked the cells and they are both set for currency. So, I tried
Trevor's formula and it worked great. Thanks guys... I never knew that
Excel can be so intriguing. I love it.

day