#1
|
|||
|
|||
SUM Two Cells Above & Format to Currency
Using MS 365
I have a table with three blank cells in one column. I want to be able to type in a currency amount in both blank cells (or have it formatted to currency) and then have Word SUM the currency amount in the other blank cell. From my research, there has to be a value in the cells and then you can add the formula =SUM(ABOVE) or just click the AutoSum button. Is there a way to: Format all cells to currency. Type in a formula to SUM the cells once values are added. Thank you in advance for your help. Karen |
#2
|
||||
|
||||
Word is not Excel and doesn't have the formatting functionality that Excel has.
In the number entry cells you will need to do the currency formatting yourself unless you are going to use a macro to modify the text after you enter it. Are you open to using macros in this document? For the field you can add formatting switches to make the result formatted. The field code might look like this { =SUM(ABOVE) \# "$#,##0.00;($#,##0.00)" }
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create currency cells in a Word Table | DelHop | Word Tables | 13 | 09-09-2021 07:36 PM |
Can you have date and currency fields detect regional settings for format? | mblackford | Mail Merge | 1 | 04-04-2019 03:38 PM |
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 |
Formatting Cells for Currency and Accounting | Sparetyme | Excel | 1 | 07-11-2010 01:26 PM |