Reformatting Numbers

[Deano478]

Hi all,

This might be a simple one I just cab't see a way to accomplish this essentially I have a column of numbers like so:

231.07
-190.77
415.23
368.63
-2917.26
-279.04
-460.4
-2131.51

I need to format the Negative Numbers like so (190.77) I'm probably missing something very simple here. 

Cheers in advance for any assistance

[Felipe_Ribeir0]

Hi @Deano478 

If you mean that you want all numbers being shown as positive numbers, you can use the abs function:

ABS([Field1])

[binuacs · Accepted solution]

@Deano478 One way of doing this

[Felipe_Ribeir0]

Ohh now i got it, @binuacs way is the right way to go.

[Deano478]

Many Thanks guys as always the community came to the rescue