Windows7 + Office '07



Is there a way to format cells within a table as accounting (as in Excel) so that the cells display a left aligned $ sign and a right aligned numeric value within each cell?

Thanks,

Mark

Click in the Table Cell > On the Ribbon, in the Layout Tab click Formula (on the right) > then Select Number Format

You may have to then use regular formating to get it the way you want to show

This becomes part of a larger problem (and a separate post in this regard)--me understanding how Word '07 (operating in compatible mode) handles math in a table since the only way to get the $ sign is to use formula.

I click on the cell in question (in this instance it'll be the sum of the above cells), click on formula, click on number format and select the $, click on paste function and select Sum and click OK (since with the box up, I cannot select the range of cells above as I would with Excel) and I end up with a syntax error in the cell presumably because there's no range for the sum!

Mark

Since Word is NOT really for any real number crunching, I think I would set things up in Excel, copy, then go to Word > Paste Special > Microsoft Office Excel Worksheet Object

Then, if I needed farther refinement, I double click in the imported spreadsheet