Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-19-2014, 07:47 AM
DelHop DelHop is offline How do I create currency cells in a Word Table Windows 8 How do I create currency cells in a Word Table Office 2013
Novice
How do I create currency cells in a Word Table
 
Join Date: May 2014
Location: Cape Town
Posts: 2
DelHop is on a distinguished road
Question How do I create currency cells in a Word Table


I need small table in Word. How do I convert 2 columns to currency cells. This will automatically insert the currency decimal separation points in the currency?
Reply With Quote
  #2  
Old 05-19-2014, 03:15 PM
macropod's Avatar
macropod macropod is offline How do I create currency cells in a Word Table Windows 7 32bit How do I create currency cells in a Word Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Word tables don't have any automatic cell formats. If you want a currency format, you have to apply it to each cell yourself. Other than typing the currency format manually, you could use a macro to format the cells, perhaps attached to a content control on-exit macro (but only if you use content controls) or a macrobutton field, or if you use formfields in a document with forms protection. See, for example: https://www.msofficeforums.com/16726-post2.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-20-2014, 04:28 AM
DelHop DelHop is offline How do I create currency cells in a Word Table Windows 8 How do I create currency cells in a Word Table Office 2013
Novice
How do I create currency cells in a Word Table
 
Join Date: May 2014
Location: Cape Town
Posts: 2
DelHop is on a distinguished road
Smile Appreciation

Thank you for the help. Thought I could make my life a bit easier, but no chance of that
Reply With Quote
  #4  
Old 05-20-2014, 04:30 AM
macropod's Avatar
macropod macropod is offline How do I create currency cells in a Word Table Windows 7 32bit How do I create currency cells in a Word Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If it suits your purposes you could embed an Excel worksheet in the document. That will give you access to all of Excel's functionality.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 06-09-2014, 10:26 AM
kd12 kd12 is offline How do I create currency cells in a Word Table Windows 7 64bit How do I create currency cells in a Word Table Office 2013
Banned
 
Join Date: Jun 2014
Location: Massachusetts
Posts: 10
kd12 is on a distinguished road
Default

Create a macro. It takes a little bit of effort, but then it will be super super easy.

I can't take the credit for this macro, it comes from here: http://ask.brothersoft.com/how-do-i-...le-113359.html
  • From the Developer tab, click the Macros button.
  • From the Macros in drop-down list, select Normal.dotm (this will make this macro available in all of your documents not just this one.
  • Enter a name for the Macro
  • Click the Create button.
  • The editor window opens.
  • Paste the following into the editor:
Code:
Sub CurrencyTableFormat() 
     '
     ' CurrencyTableFormat Macro
     '
     '
    Dim tCell As Word.Cell 
    Dim tRange As Range 
    If Selection.Type = wdSelectionIP Or Not Selection.Information(wdWithInTable) Then 
        MsgBox "Select numerical values in tables cells before running this macro.", , "Error" 
        Exit Sub 
    End If 
    For Each tCell In Selection.Cells 
        Set tRange = tCell.Range 
        tRange.End = tRange.End - 1 
        With tRange 
            If IsNumeric(tRange) Then 
                .Text = FormatCurrency(Expression:=.Text) 
            End If 
            On Error Goto Skip 
Skip: 
        End With 
    Next tCell 
End Sub
  • Save and close
  • Highlight the two columns, and run the macro
NOTE: The editor will have the "Sub [TITLE], the [TITLE] Macro and the End Sub lines already filled in, so you really just need to copy from Dim to tCell. Or you can use the title I used and just copy the whole thing

Last edited by macropod; 06-13-2014 at 03:46 PM. Reason: Added code tags & formatting
Reply With Quote
  #6  
Old 06-09-2014, 04:40 PM
macropod's Avatar
macropod macropod is offline How do I create currency cells in a Word Table Windows 7 32bit How do I create currency cells in a Word Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

kate: If you read posts 2 & 3 in this thread, you will see that a macro was suggested (and a link to one provided), but the response was "Thought I could make my life a bit easier, but no chance of that." That makes it fairly obvious a macro such as you've posted isn't a solution in this case, apart from which, it doesn't address the underlying issue of the OP wanting the formatting to occur as the data are entered. The only ways of achieving that are as outlined in posts 2 & 4.

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 06-09-2014, 08:49 PM
kd12 kd12 is offline How do I create currency cells in a Word Table Windows 7 64bit How do I create currency cells in a Word Table Office 2013
Banned
 
Join Date: Jun 2014
Location: Massachusetts
Posts: 10
kd12 is on a distinguished road
Default

Hey Paul,

Yes I did read through but not everyone is familiar with macros and how to use them. It's easy to assume that they're hard to manipulate and won't make life easier. But sometimes, when it's spelled out like that, it doesn't look as difficult. IMO, more info is never a bad thing

And I don't usually use the code tags for short things like that because I find it cumbersome and annoying to read. It's a personal preference for short codes like that. But I appreciate the advice!

- K
Reply With Quote
  #8  
Old 06-09-2014, 08:55 PM
macropod's Avatar
macropod macropod is offline How do I create currency cells in a Word Table Windows 7 32bit How do I create currency cells in a Word Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by kate12402 View Post
And I don't usually use the code tags for short things like that because I find it cumbersome and annoying to read. It's a personal preference for short codes like that.
That's not acceptable here, though.

One very good reason for using code tags is that they preserve the code layout. If you look at the code you posted, all the structure has gone. You may not care about that, but most people find structured code much easier to understand. If it was just one or two lines, fair enough, but not for whole subs - and it only takes a few seconds to do.

Please keep that in mind for future posts.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 06-16-2014, 10:37 AM
leonardmonk leonardmonk is offline How do I create currency cells in a Word Table Windows XP How do I create currency cells in a Word Table Office XP
Novice
 
Join Date: Jun 2014
Posts: 1
leonardmonk is on a distinguished road
Default

I would like to format cells in a table in Microsoft word to automatically show as currency. .

ONLINE CASINO AUSTRALIA

Last edited by leonardmonk; 06-17-2014 at 05:12 AM.
Reply With Quote
  #10  
Old 06-16-2014, 03:42 PM
macropod's Avatar
macropod macropod is offline How do I create currency cells in a Word Table Windows 7 32bit How do I create currency cells in a Word Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Have you read the previous discussion?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 11-24-2019, 04:37 AM
CHINAMILL CHINAMILL is offline How do I create currency cells in a Word Table Windows 10 How do I create currency cells in a Word Table Office 2019
Novice
 
Join Date: Nov 2019
Posts: 1
CHINAMILL is on a distinguished road
Default Yikes help!

Is there an update on this yet? 2019 version. or How to do multiplication inside a cell like you can do on excel?
Reply With Quote
  #12  
Old 11-24-2019, 02:37 PM
macropod's Avatar
macropod macropod is offline How do I create currency cells in a Word Table Windows 7 64bit How do I create currency cells in a Word Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Nothing has changed in how Word tables work. If you don't want to embed an Excel worksheet in the document, see my Microsoft Word Field Maths Tutorial, at:
Microsoft Word Field Maths Tutorial
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #13  
Old 09-09-2021, 04:26 PM
carlosnorvik carlosnorvik is offline How do I create currency cells in a Word Table Mac OS X How do I create currency cells in a Word Table Office 2016 for Mac
Novice
 
Join Date: Sep 2021
Posts: 1
carlosnorvik is on a distinguished road
Default

I open the file in LibreOffice and format the cells tehre, very easy to do.
Reply With Quote
  #14  
Old 09-09-2021, 07:36 PM
macropod's Avatar
macropod macropod is offline How do I create currency cells in a Word Table Windows 10 How do I create currency cells in a Word Table Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

This is hardly a relevant response to a Word problem that was answered over seven years ago...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird: 2 cells with data in Word 2010 table will not print! Mendopaul Word 8 03-23-2014 02:18 PM
How do I create currency cells in a Word Table Word 2007 Table - Shift Cells INDYBUG Word Tables 1 09-29-2013 05:47 PM
How do I create currency cells in a Word Table Word VBA: add textboxs in table cells? tinfanide Word VBA 12 02-09-2012 12:05 AM
How do I create currency cells in a Word Table Set range for merged Word table cells? tinfanide Word VBA 1 02-06-2012 05:57 AM
Formatting Cells for Currency and Accounting Sparetyme Excel 1 07-11-2010 01:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft