Reply to comment
The formula looks like this:
Right("00" & Left([IP Address], "."), 3) & "." &
Right("00" & Left(Right([IP Address], -1 + Length([Ip Address]) - Length(Left([IP Address],"."))),"."),3) & "." &
Right("00" & Right(Left([IP Address], -1 + Length([Ip Address]) - Length(Right([IP Address],"."))),"."),3) & "." &
Right("00" & Right([IP Address], "."), 3)
This formula field might be used only for sorting and not for display purposes.
Thanks to Keith Ratliff for the formula.
- 38075 reads


