Number with space

[simoncpage]

Is it possible to have a field which only takes number but allows spaces?

[Robert Kidd]

Set your text field as validate by calculation=

Substitute ( FieldA; " "; "") = GetAsNumber(Substitute ( FieldA; " "; ""))

Use TextToNum for pre V7 in lieu of GetAsNumber

[simoncpage]

hmm seems to be a problem is the number in the cell begins with a 0

"012" is picked up as invalid

[simoncpage]

Have used:

If(Left(FieldA, 1) <> 0, Substitute( FieldA, " ", "") = TextToNum(Substitute( FieldA, " ", "")), Substitute( Right(FieldA, Length(FieldA)-1), " ", "") = TextToNum(Substitute( Right(FieldA, Length(FieldA)-1), " ", "")))

?

[Robert Kidd]

Or:

Substitute(Substitute(test;0;"");" ";"") = GetAsNumber(Substitute(Substitute(test;0;"");" ";"") )