1 Reply Latest reply on Jan 4, 2010 10:16 AM by StellaLuna

    Create Spaces In A Field

    2blues

      Title

      Create Spaces In A Field

      Post

      Hi,

       

      I just wanna know how to create spaces between numbers in one field. So I want this - 456899233, to look like this -     456 899 233.

       

      Thanks

        • 1. Re: Create Spaces In A Field
          StellaLuna
            

          Then this should not be a number field but rather text. and you could change data or prefer to create a calculation with

           

          Left(field;3) & " " & Middle(field;4;3) & " " & Right(field;3)

           

          if the field ever contains anything else but numbers or a different number of numbers then we will have to make adjustments.