PC Review


Reply
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average.

Auto Convert -figure to (figure)

 
 
=?Utf-8?B?T25n?=
Guest
Posts: n/a
 
      2nd Jul 2004
How to Auto convert the figure -9999.99 to (9999.99)?
 
Reply With Quote
 
 
 
 
Jezebel
Guest
Posts: n/a
 
      2nd Jul 2004
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" <(E-Mail Removed)> wrote in message
news:80D6401E-1C38-4C50-B944-(E-Mail Removed)...
> How to Auto convert the figure -9999.99 to (9999.99)?



 
Reply With Quote
 
=?Utf-8?B?T25n?=
Guest
Posts: n/a
 
      2nd Jul 2004
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" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:80D6401E-1C38-4C50-B944-(E-Mail Removed)...
> > How to Auto convert the figure -9999.99 to (9999.99)?

>
>
>

 
Reply With Quote
 
Jezebel
Guest
Posts: n/a
 
      2nd Jul 2004
I was talking about using Find and Replace. I doubt there's an autocorrect
method for this.



"Ong" <(E-Mail Removed)> wrote in message
news:82A71D40-A03F-4C98-9985-(E-Mail Removed)...
> 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" wrote:
>
> > 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" <(E-Mail Removed)> wrote in message
> > news:80D6401E-1C38-4C50-B944-(E-Mail Removed)...
> > > How to Auto convert the figure -9999.99 to (9999.99)?

> >
> >
> >



 
Reply With Quote
 
=?Utf-8?B?T25n?=
Guest
Posts: n/a
 
      3rd Jul 2004
Is there any method to auto change the figure -9999.99 to (9999.99) when we type?


"Jezebel" wrote:

> I was talking about using Find and Replace. I doubt there's an autocorrect
> method for this.
>
>
>
> "Ong" <(E-Mail Removed)> wrote in message
> news:82A71D40-A03F-4C98-9985-(E-Mail Removed)...
> > 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" wrote:
> >
> > > 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" <(E-Mail Removed)> wrote in message
> > > news:80D6401E-1C38-4C50-B944-(E-Mail Removed)...
> > > > How to Auto convert the figure -9999.99 to (9999.99)?
> > >
> > >
> > >

>
>
>

 
Reply With Quote
 
garfield-n-odie
Guest
Posts: n/a
 
      3rd Jul 2004
Why are you deliberately typing it the wrong way and then trying to make
Word fix it for you? Just type it the way you want it to appear.


Ong wrote:

> Is there any method to auto change the figure -9999.99 to (9999.99) when we type?
>
>
> "Jezebel" wrote:
>
>
>>I was talking about using Find and Replace. I doubt there's an autocorrect
>>method for this.
>>
>>
>>
>>"Ong" <(E-Mail Removed)> wrote in message
>>news:82A71D40-A03F-4C98-9985-(E-Mail Removed)...
>>
>>>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" wrote:
>>>
>>>
>>>>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" <(E-Mail Removed)> wrote in message
>>>>news:80D6401E-1C38-4C50-B944-(E-Mail Removed)...
>>>>
>>>>>How to Auto convert the figure -9999.99 to (9999.99)?
>>>>
>>>>
>>>>

>>
>>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Figure to Time HH:ss FerrariWA Microsoft Excel Misc 2 6th Feb 2009 10:01 PM
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE Nad.Engoor Microsoft Excel Worksheet Functions 3 30th Dec 2008 03:04 PM
Word 2007 - cross reference to figure reproduces figure plus capti =?Utf-8?B?Qm9yaXM=?= Microsoft Word Document Management 2 7th Sep 2007 09:48 AM
how do I link the text about figure number to the figure caption? =?Utf-8?B?Y3J5c3RhbHhk?= Microsoft Word Document Management 1 3rd Apr 2006 06:58 PM
Format Figure Dollar to Text Figure Michael Chong Microsoft Excel Discussion 1 26th Oct 2004 11:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:07 PM.