code to rewrite numbers

romanticbiro · #1 02-11-2014, 07:41 AM

dear gmaxey
thanks very much for your help.

please
could you explain this code
i tried it via find and replace command
the question
if the number 10:50 need to be 50:10
this work or need to change thing?

another point, is any solution let word show numbers from right to left as we wrote? to not need to write wrong to show right
many thanks again

macropod · #2 02-14-2014, 09:55 PM

Quote:

Originally Posted by romanticbiro

if the number 10:50 need to be 50:10
this work or need to change thing?

another point, is any solution let word show numbers from right to left as we wrote? to not need to write wrong to show right
many thanks again

Did you try the macro?

FWIW, the equivalent wildcard Find/Replace without using a macro is:

Code:

Find = ([0-9]{1,})(:)([0-9]{1,})
Replace = \3\2\1

However, both that and the macro are dependent on your PC's regional settings. A wildcard Find/Replace that should work independently of your regional settings is:

Code:

Find = (<[0-9]@)(:)([0-9]@>)
Replace = \3\2\1

You could also use the same expressions in the macro.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to change the formatting of numbers without changing the numbers?	sullengirl	Word	2	01-27-2014 03:06 PM
How do I refer to page numbers, when the numbers change as I prepare the document?	StevenD	Word	5	11-29-2012 12:52 AM
Where does my code go?	rbaldwin	Word VBA	3	03-14-2012 02:31 PM
Page Numbers Not Matching Chapter Numbers	gracie5290	Word	1	02-02-2012 11:41 PM
Extract Numbers from Zip Code	Karen615	Excel	3	09-21-2011 06:54 AM