|
|
#3
05-29-2016, 03:07 AM
|
|||
|
|||
Thanks
If should have known better. I used to be an analyst/programmer and forgot about logical functions. I note that the function VAL is not in Excel. When a cell is blank and the cell is formatted as a number (this occurs when you initially format it as a number) how can you test if the cell contains nothing (ie blank) rather than containing the value zero - actually can you test if the cell is blank OR zero? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| prevent repetition in form | johnbest | Word VBA | 2 | 03-31-2015 11:42 PM |
 Prevent Copying and Pasting
|
Jimmy Tsawo | Excel | 3 | 02-20-2014 03:54 AM |
|
How can I PREVENT headings I don't want?
|
peytontodd | Word | 3 | 11-23-2013 05:08 PM |
| Prevent Overlap of Appointments | irab88 | Outlook | 0 | 08-03-2010 10:43 AM |
| text box, prevent from printing | Tanya | Word | 0 | 02-05-2010 06:57 AM |
Windows XP 
Office 2010 32bit
Threaded Mode