Posted to microsoft.public.excel.programming

MikeF[_2_] MikeF[_2_] is offline

external usenet poster

Posts: 173

Zeros in blanks

I have zeros for blanks turned off as an Excel option.
But in some ranges on some sheets, need a "if cell value = "" then make it
zero" routine.

Best suggestions??

Thanx,
- Mike

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
Counting blanks as zeros	bob	Excel Worksheet Functions	1	November 26th 09 06:04 PM
Blanks or zeros in formulas	Dannn78	Excel Discussion (Misc queries)	3	August 22nd 08 01:09 AM
formulas blanks vs zeros	Dallasbutterfly	Excel Discussion (Misc queries)	1	August 30th 07 10:52 PM
Vlookup blanks = zeros	Marilyn	Excel Discussion (Misc queries)	6	March 18th 07 01:21 AM
Blanks chart as zeros	CLR	Charts and Charting in Excel	10	April 11th 05 01:38 AM

All times are GMT +1. The time now is 12:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us