Leaving a field blank if value is "0"

[john h]

Hey Folks...

Probably a simple answer to this, but I'm stumped. I have a numerical field
and want the field left blank by default until I enter a number in it. It
currently fills all cells with "0". Any advice is appreciated!! john

 

[Dale Howard [MVP]]

john h --

There's no way to work around this. What you see is how the software works.
Hope this helps.

 

[Jonathan Sofer]

You cannot leave a numeric field blank, it will always show 0 if no value is
entered.

You could play around with using a large negative number to represent null.
Like -9999 or something to that effect.

 

[Jack Dahlgren]

Use a text field.
The math will work just the same and if you want you can control the
formatting.

-Jack Dahlgren

 

[john h]

Thanks folks, simple problem, simple solution!!

Use a text field.
The math will work just the same and if you want you can control the
formatting.

-Jack Dahlgren