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.77415.23368.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

Reformatting Numbers

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:

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

Workflow

Help

@Deano478 One way of doing this

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

ABS([Field1])

abs.yxmd

@Deano478 One way of doing this

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

Many Thanks guys as always the community came to the rescue