Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A in 150 WS
hi: I have a wb with 150 ws. some cell in some ws have an #N/A and ther is no formula in the cell. how can I replace the # with a blank o just plainly turn that cell value to zero. I have way to many ws to d it by hand. any help is greatly appreciated -- halem ----------------------------------------------------------------------- halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993 View this thread: http://www.excelforum.com/showthread.php?threadid=55749 |