How to make a number field empty

1

I want to make a number field empty, but if I set it to “”, a zero shows up.

How can I make it empty instead?

2

Set it to zeroblank(“”).

3

In addition to Gary’s suggestion, you can use Delete from the Edit menu, and the ClearCell command will do it if the cell in question is the active cell.

4

Here is the documentation of the zeroblank() function:

zeroblank( function

5

Set it to zeroblank(“”).

I tried this and it does work, but I would suggest that best practices would be:

TheField = zeroblank(0)

If you want to make the entire field empty, use

field TheField
formulafill zeroblank(0)

Note: This also works for Date fields.

6

Field>Morph>Clear Field. That clears it for every record.