Posted to microsoft.public.excel.programming

Charlie_Brown[_2_] Charlie_Brown[_2_] is offline

external usenet poster

Posts: 1

how to remove #N/A

I have a large spreadhsheet (21k rows) that creates alot of #N/A as designed.
I would like to change the #N/A to zero removing the formula. This is not a
one time deal as I need to re-create the spreadsheet weekly. I do not want
to value out the entire spreadsheet.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i remove an excel link that break link won't remove	brosull	Excel Worksheet Functions	1	June 29th 09 06:34 PM
remove convert/extract the number from'12345.56; ie remove ' sign	WAN	Excel Worksheet Functions	2	January 10th 08 12:38 PM
How do I remove hyperlink if 'remove' option is disabled	Vipul	New Users to Excel	1	January 8th 08 02:34 PM
remove #DIV/0!	Dopase via OfficeKB.com	Excel Worksheet Functions	4	June 15th 06 04:35 PM
Is there a way to remove numbers w/o remove formulas	Annette[_3_]	Excel Programming	2	July 23rd 03 07:29 PM

All times are GMT +1. The time now is 04:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us