A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do you change a number e.g 1034 to currency $10.34 in 2007?



 
 
Thread Tools Display Modes
  #1  
Old October 23rd, 2009, 06:29 AM posted to microsoft.public.word.tables
Help with Word 2007
external usenet poster
 
Posts: 1
Default how do you change a number e.g 1034 to currency $10.34 in 2007?

I have searched high and low in the useless Microsoft online help in 2007 for
basic formatting functionality that appears to be very well hidden. Can
someone please let me know if they have found any, eg commas, numbers into
currency, etc.

thanks
  #2  
Old October 23rd, 2009, 07:22 AM posted to microsoft.public.word.tables
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default how do you change a number e.g 1034 to currency $10.34 in 2007?

Hi,

Word has no built-in formatting functions for numbers typed intoa document from the keyboard - you have to apply the formatting
manually. Formfields inserted via the Developer Tab, and fields inserted via Insert|Quick Parts|Field can have formatting applies to
their contents, though.

--
Cheers
macropod
[Microsoft MVP - Word]


"Help with Word 2007" Help with Word wrote in message
news
I have searched high and low in the useless Microsoft online help in 2007 for
basic formatting functionality that appears to be very well hidden. Can
someone please let me know if they have found any, eg commas, numbers into
currency, etc.

thanks


  #3  
Old October 23rd, 2009, 07:25 AM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default how do you change a number e.g 1034 to currency $10.34 in 2007?

It depends where the number has come from. There is no way to automatically
format typed numbers as currency on the fly in any Word version. You would
need a field e.g. to turn 1034 into $10.34 you would need a calculation
field { =1034 / 100 \# "$,0.00" }. If you need typed numbers formatted as
currency then it is quicker simply to type them as such.

or you could select the number and use a macro - in this instance

Dim rNum As Range
Set rNum = Selection.Range
If IsNumeric(rNum.Text) = False Then
MsgBox "No number selected", vbInformation, "Error"
Exit Sub
End If
rNum.Fields.Add rNum, wdFieldExpression, rNum.Text & " /100 \# $,0.00",
False

http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Help with Word 2007 wrote:
I have searched high and low in the useless Microsoft online help in
2007 for basic formatting functionality that appears to be very well
hidden. Can someone please let me know if they have found any, eg
commas, numbers into currency, etc.

thanks



  #4  
Old October 23rd, 2009, 01:16 PM posted to microsoft.public.word.tables
Pesach Shelnitz[_2_]
external usenet poster
 
Posts: 228
Default how do you change a number e.g 1034 to currency $10.34 in 2007

Hi,

Since this question was asked in the Tables newsgroup, I would just add that
the formula field mentioned by Graham can also be used within a table to
display the result of a calculation on numbers in a table as well as
bookmarked numbers. For example, if the number 25 appears in the second
column in the fifth row (cell B5) and $41.36 appears in the thrid column in
the same row (cell C5), you can display the result of multiplying these two
numbers in currency format in any other cell in the table, for example, in
the fourth column of the same row, by inserting the formula field {=B5*C5 \#
$##,##0.00} in the cell. Note that you do not type the curly brackets ({})
for field codes. Instead, select whatever is to be enclosed by them, press
Ctrl+F9, and then press F9.

The formula field is actually documented in the Word 2007 online help at
http://office.microsoft.com/en-us/wo...387981033.aspx.

--
Hope this helps,
Pesach Shelnitz


"Graham Mayor" wrote:

It depends where the number has come from. There is no way to automatically
format typed numbers as currency on the fly in any Word version. You would
need a field e.g. to turn 1034 into $10.34 you would need a calculation
field { =1034 / 100 \# "$,0.00" }. If you need typed numbers formatted as
currency then it is quicker simply to type them as such.

or you could select the number and use a macro - in this instance

Dim rNum As Range
Set rNum = Selection.Range
If IsNumeric(rNum.Text) = False Then
MsgBox "No number selected", vbInformation, "Error"
Exit Sub
End If
rNum.Fields.Add rNum, wdFieldExpression, rNum.Text & " /100 \# $,0.00",
False

http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Help with Word 2007 wrote:
I have searched high and low in the useless Microsoft online help in
2007 for basic formatting functionality that appears to be very well
hidden. Can someone please let me know if they have found any, eg
commas, numbers into currency, etc.

thanks



.

  #5  
Old October 23rd, 2009, 01:48 PM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default how do you change a number e.g 1034 to currency $10.34 in 2007

{=B5*C5 \# $,0.00} has a somewhat more elegant formatting switch and will do
the same job

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Pesach Shelnitz wrote:
Hi,

Since this question was asked in the Tables newsgroup, I would just
add that the formula field mentioned by Graham can also be used
within a table to display the result of a calculation on numbers in a
table as well as bookmarked numbers. For example, if the number 25
appears in the second column in the fifth row (cell B5) and $41.36
appears in the thrid column in the same row (cell C5), you can
display the result of multiplying these two numbers in currency
format in any other cell in the table, for example, in the fourth
column of the same row, by inserting the formula field {=B5*C5 \#
$##,##0.00} in the cell. Note that you do not type the curly brackets
({}) for field codes. Instead, select whatever is to be enclosed by
them, press Ctrl+F9, and then press F9.

The formula field is actually documented in the Word 2007 online help
at http://office.microsoft.com/en-us/wo...387981033.aspx.


It depends where the number has come from. There is no way to
automatically format typed numbers as currency on the fly in any
Word version. You would need a field e.g. to turn 1034 into $10.34
you would need a calculation field { =1034 / 100 \# "$,0.00" }. If
you need typed numbers formatted as currency then it is quicker
simply to type them as such.

or you could select the number and use a macro - in this instance

Dim rNum As Range
Set rNum = Selection.Range
If IsNumeric(rNum.Text) = False Then
MsgBox "No number selected", vbInformation, "Error"
Exit Sub
End If
rNum.Fields.Add rNum, wdFieldExpression, rNum.Text & " /100 \#
$,0.00", False

http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Help with Word 2007 wrote:
I have searched high and low in the useless Microsoft online help in
2007 for basic formatting functionality that appears to be very well
hidden. Can someone please let me know if they have found any, eg
commas, numbers into currency, etc.

thanks



.



  #6  
Old October 26th, 2009, 11:56 PM posted to microsoft.public.word.tables
Help with Word 2007[_2_]
external usenet poster
 
Posts: 4
Default how do you change a number e.g 1034 to currency $10.34 in 2007

Thanks all for your clarification.

"Graham Mayor" wrote:

{=B5*C5 \# $,0.00} has a somewhat more elegant formatting switch and will do
the same job

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Pesach Shelnitz wrote:
Hi,

Since this question was asked in the Tables newsgroup, I would just
add that the formula field mentioned by Graham can also be used
within a table to display the result of a calculation on numbers in a
table as well as bookmarked numbers. For example, if the number 25
appears in the second column in the fifth row (cell B5) and $41.36
appears in the thrid column in the same row (cell C5), you can
display the result of multiplying these two numbers in currency
format in any other cell in the table, for example, in the fourth
column of the same row, by inserting the formula field {=B5*C5 \#
$##,##0.00} in the cell. Note that you do not type the curly brackets
({}) for field codes. Instead, select whatever is to be enclosed by
them, press Ctrl+F9, and then press F9.

The formula field is actually documented in the Word 2007 online help
at http://office.microsoft.com/en-us/wo...387981033.aspx.


It depends where the number has come from. There is no way to
automatically format typed numbers as currency on the fly in any
Word version. You would need a field e.g. to turn 1034 into $10.34
you would need a calculation field { =1034 / 100 \# "$,0.00" }. If
you need typed numbers formatted as currency then it is quicker
simply to type them as such.

or you could select the number and use a macro - in this instance

Dim rNum As Range
Set rNum = Selection.Range
If IsNumeric(rNum.Text) = False Then
MsgBox "No number selected", vbInformation, "Error"
Exit Sub
End If
rNum.Fields.Add rNum, wdFieldExpression, rNum.Text & " /100 \#
$,0.00", False

http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Help with Word 2007 wrote:
I have searched high and low in the useless Microsoft online help in
2007 for basic formatting functionality that appears to be very well
hidden. Can someone please let me know if they have found any, eg
commas, numbers into currency, etc.

thanks


.



.

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.