Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
change decimal dots per coma (in word)
Having a table with numbers in word, how can I change decimal dots per coma?
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
change decimal dots per coma (in word)
Select the cells containing the numbers and use EditReplace
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gabriela" wrote in message ... Having a table with numbers in word, how can I change decimal dots per coma? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
change decimal dots per coma (in word)
Select the cells containing the numbers and use EditReplace
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gabriela" wrote in message ... Having a table with numbers in word, how can I change decimal dots per coma? |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
change decimal dots per coma (in word)
Can you set regional preferences for currency etc. in Word, or is that
strictly a Windows thing? On May 3, 7:02*pm, "Doug Robbins - Word MVP" wrote: Select the cells containing the numbers and use EditReplace -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gabriela" wrote in message ... Having a table with numbers in word, how can I change decimal dots per coma?- |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
change decimal dots per coma (in word)
Can you set regional preferences for currency etc. in Word, or is that
strictly a Windows thing? On May 3, 7:02*pm, "Doug Robbins - Word MVP" wrote: Select the cells containing the numbers and use EditReplace -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gabriela" wrote in message ... Having a table with numbers in word, how can I change decimal dots per coma?- |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
change decimal dots per coma (in word)
The numeric formatting switches in Word will follow the regional currency
preferences as long as the switch conforms to that preference setting. That is uses , where a , is expected and a period where a period is expected, etc. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Peter T. Daniels" wrote in message ... Can you set regional preferences for currency etc. in Word, or is that strictly a Windows thing? On May 3, 7:02 pm, "Doug Robbins - Word MVP" wrote: Select the cells containing the numbers and use EditReplace -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gabriela" wrote in message ... Having a table with numbers in word, how can I change decimal dots per coma?- |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
change decimal dots per coma (in word)
The numeric formatting switches in Word will follow the regional currency
preferences as long as the switch conforms to that preference setting. That is uses , where a , is expected and a period where a period is expected, etc. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Peter T. Daniels" wrote in message ... Can you set regional preferences for currency etc. in Word, or is that strictly a Windows thing? On May 3, 7:02 pm, "Doug Robbins - Word MVP" wrote: Select the cells containing the numbers and use EditReplace -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gabriela" wrote in message ... Having a table with numbers in word, how can I change decimal dots per coma?- |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
change decimal dots per coma (in word)
On Mon, 3 May 2010 15:23:01 -0700, Gabriela
wrote: Having a table with numbers in word, how can I change decimal dots per coma? In addition to what Doug said I should add something else because I frequently have this problem too. I often have a lot of numbers in tables with the "European" format like this: 321.576,98 That is, "." separates the thousands and "," separates the decimal fraction. I need to change these numbers to "English" format like this: 321,576.98 The way to do this is first find and replace all of the "." to another character that doesn't exist in the table, say "|". Next find and replace all of the "," to ".". Finally find and replace all of the "|" to ",". The following is a macro that I've been using to do this for many years: begin macro Sub ToggleCommasAndPeriods() ' ' ChangeFormatOfSelectedNumber Macro ' Macro created 24-Mar-05 by Greg Maxey ' Dim myRange As Range If Selection.Type = wdSelectionIP Then MsgBox "Select text before running this macro.", , "Nothing Selected" End End If Set myRange = Selection.Range myRange = Replace(myRange, ".", "..") myRange = Replace(myRange, ",", ",,") myRange = Replace(myRange, ",,", ".") myRange = Replace(myRange, "..", ",") With myRange If Left(.Text, 1) = "-" Then .Text = "(" & Replace(.Text, "-", "") & ") " End If End With End Sub /end macro I can't comment on it at all except to say that it works as advertised. HTH -- Bob http://www.kanyak.com |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
change decimal dots per coma (in word)
On Mon, 3 May 2010 15:23:01 -0700, Gabriela
wrote: Having a table with numbers in word, how can I change decimal dots per coma? In addition to what Doug said I should add something else because I frequently have this problem too. I often have a lot of numbers in tables with the "European" format like this: 321.576,98 That is, "." separates the thousands and "," separates the decimal fraction. I need to change these numbers to "English" format like this: 321,576.98 The way to do this is first find and replace all of the "." to another character that doesn't exist in the table, say "|". Next find and replace all of the "," to ".". Finally find and replace all of the "|" to ",". The following is a macro that I've been using to do this for many years: begin macro Sub ToggleCommasAndPeriods() ' ' ChangeFormatOfSelectedNumber Macro ' Macro created 24-Mar-05 by Greg Maxey ' Dim myRange As Range If Selection.Type = wdSelectionIP Then MsgBox "Select text before running this macro.", , "Nothing Selected" End End If Set myRange = Selection.Range myRange = Replace(myRange, ".", "..") myRange = Replace(myRange, ",", ",,") myRange = Replace(myRange, ",,", ".") myRange = Replace(myRange, "..", ",") With myRange If Left(.Text, 1) = "-" Then .Text = "(" & Replace(.Text, "-", "") & ") " End If End With End Sub /end macro I can't comment on it at all except to say that it works as advertised. HTH -- Bob http://www.kanyak.com |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add coma | Mailmerge | |||
How do you change decimal alignment in tables? | Tables | |||
MERGE NUMBERS WITH COMA FORMATTING | Mailmerge | |||
Change a decimal point (.) by coma (,) | Mailmerge | |||
Date format changed and decimal places change in Word 2003 mail me | Mailmerge |