G
Guest
How to Auto convert the figure -9999.99 to (9999.99)?
Jezebel said:I assume you mean search for any negative number and replace the negative
with parantheses. With Use wildcards checked, search
for: -([0-9]{1,}.[0-9]{1,2}) and replace with: (\1)
This assumes that the numbers you want have at least one digit before the
decimal and one or two digits after.
Ong said:How to Auto convert the figure -9999.99 to (9999.99)?
Ong said:Dear Jezebel,
If I go to Tool--> AutoCorrect, Then put in -([0-9]{1,}.[0-9]{1,2}) in REPLACE and
(\1) in WITH. Then when I type in -599.77 and press enter, will it auto change to (599.77)?
I tried before , but not work...
From Ong.
Jezebel said:I assume you mean search for any negative number and replace the negative
with parantheses. With Use wildcards checked, search
for: -([0-9]{1,}.[0-9]{1,2}) and replace with: (\1)
This assumes that the numbers you want have at least one digit before the
decimal and one or two digits after.
Ong said:How to Auto convert the figure -9999.99 to (9999.99)?
Jezebel said:I was talking about using Find and Replace. I doubt there's an autocorrect
method for this.
Ong said:Dear Jezebel,
If I go to Tool--> AutoCorrect, Then put in -([0-9]{1,}.[0-9]{1,2}) in REPLACE and
(\1) in WITH. Then when I type in -599.77 and press enter, will it auto change to (599.77)?
I tried before , but not work...
From Ong.
Jezebel said:I assume you mean search for any negative number and replace the negative
with parantheses. With Use wildcards checked, search
for: -([0-9]{1,}.[0-9]{1,2}) and replace with: (\1)
This assumes that the numbers you want have at least one digit before the
decimal and one or two digits after.
How to Auto convert the figure -9999.99 to (9999.99)?
Is there any method to auto change the figure -9999.99 to (9999.99) when we type?
:
I was talking about using Find and Replace. I doubt there's an autocorrect
method for this.
Dear Jezebel,
If I go to Tool--> AutoCorrect, Then put in -([0-9]{1,}.[0-9]{1,2}) in
REPLACE and
(\1) in WITH. Then when I type in -599.77 and press enter, will it auto
change to (599.77)?
I tried before , but not work...
From Ong.
:
I assume you mean search for any negative number and replace the
negative
with parantheses. With Use wildcards checked, search
for: -([0-9]{1,}.[0-9]{1,2}) and replace with: (\1)
This assumes that the numbers you want have at least one digit before
the
decimal and one or two digits after.
How to Auto convert the figure -9999.99 to (9999.99)?