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
john h -- There's no way to work around this. What you see is how the software works. Hope this helps. -- Dale A. Howard [MVP] VP of Educational Services msProjectExperts http://www.msprojectexperts.com http://www.projectserverexperts.com "We write the books on Project Server" "john h" <john h@discussions.microsoft.com> wrote in message news:EE4E1D2E-2E0C-4E38-A73E-2221926C61D8@microsoft.com... > 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
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. -- Jonathan Sofer [MVP] http://www.epmcentral.com "john h" <john h@discussions.microsoft.com> wrote in message news:EE4E1D2E-2E0C-4E38-A73E-2221926C61D8@microsoft.com... > 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
Use a text field. The math will work just the same and if you want you can control the formatting. -Jack Dahlgren "john h" wrote: > 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
Thanks folks, simple problem, simple solution!! "Jack Dahlgren" wrote: > Use a text field. > The math will work just the same and if you want you can control the > formatting. > > -Jack Dahlgren > > > > > "john h" wrote: > > > 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
