View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rexmann rexmann is offline
external usenet poster
 
Posts: 79
Default Not showing #N/A

Hi

Is there a way to set the excel column so it does not display the #N/A

I have a spreadsheet with a V-look up ready to calculate when the user
enters the details but until this happens it comes up with a little green
triangle and a #N/A - where I want it to remain blank

Any suggestions greatly appreciated