Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-03-2024, 05:28 PM
Melsy Melsy is offline Change Word Table format to Currency Windows 10 Change Word Table format to Currency Office 2016
Novice
Change Word Table format to Currency
 
Join Date: May 2023
Location: Sydney, Australia
Posts: 6
Melsy is on a distinguished road
Question Change Word Table format to Currency


Hi All,

I was hoping to get some help to create a macro that will change the format of my word table column.

Table 2, Column 2, from Row 2 and all rows below. (note: the table has column headings).

The font needs to stay the same, only the numbers need to be formatted into currency format so it looks like this > $ 1,000,000.00 > and aligned to the bottom right of the cell.

Also, this particular column then has an "update totals" macro which sums all these amounts onto another table (Table 3), so I'm hoping this will not break the update totals macro.

Ideally I want it to format the numbers to currency format, prior to updating the totals.

Any help you can give me would truly be appreciated!

Thanks in advance
Reply With Quote
 

Tags
currency, format cells, word table



Similar Threads
Thread Thread Starter Forum Replies Last Post
SUM Two Cells Above & Format to Currency Karen615 Word Tables 1 12-01-2023 03:00 PM
Change Word Table format to Currency How do I create currency cells in a Word Table DelHop Word Tables 11 11-24-2019 02:37 PM
Change Word Table format to Currency Why do currency cells automatically change to date format on some worksheets Hil Excel 1 09-16-2015 10:34 AM
Currency format in form travelred Word 2 11-14-2014 06:15 AM
Change Word Table format to Currency change currency $ to £ on excel invoice help deanorx7 Excel 3 07-08-2008 04:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:39 AM.


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