Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
Is there a simple way or does anyone have anyway to turn negative strings with () into -.
example of field data:
9056
11209
(495)
(44245)
49300
You have to change the Format Pattern on the Number tab:
For example, change ###########,### to ###########,###;-###########,### for a -
or change ###########,### to ###########,###;(###########,###) for ()
Hi you can use:
Num#(replace(replace('(14)', '(', '-'), ')', ''))
Put your field instead of '(14)' in the formula.
That is exactly what I had done but it still gives me text data type. I go from:
(4302)
5069
7869
to:
-4302
5069
7869
When you say "text data" you mean the display in a chart is the display used for text ?
In my test it works.
Please find below
I'm not sure what type the data is, but in a list box it aligns the way text data is supposed to. Other numbers align to the right.
Here's my document
Ok got it.
Remove the "," too when you replace the "( )".
Sorry can you show me the correct code. I don't see an extra ,