Forcing a #value

[Chrissirhc]

Hi,

What is the easiest, cleanest and most conventional way to force a #value. For example, forcing a #NA I would just use =NA().

Thanks in advance,

Chris

 

[taupirho]

Try this =NOT("A")

 

[firefytr]

Or use a mathematical operation on text. Ie ..

=0+""

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci