Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2010, 06:52 AM
markg2 markg2 is offline Table format $ Windows 7 Table format $ Office 2007
Expert
Table format $
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 335
markg2 is on a distinguished road
Default Table format $

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
Reply With Quote
  #2  
Old 01-16-2010, 03:00 PM
zyzzyva57 zyzzyva57 is offline Table format $ Windows 7 Table format $ Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 01-16-2010, 04:24 PM
markg2 markg2 is offline Table format $ Windows 7 Table format $ Office 2007
Expert
Table format $
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 335
markg2 is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 01-16-2010, 06:43 PM
zyzzyva57 zyzzyva57 is offline Table format $ Windows 7 Table format $ Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
numbering in .rtf format Vakar Word 0 10-15-2009 03:48 AM
Format a Row Eagle710 Excel 0 08-05-2009 08:57 AM
Table format $ Is there a way to Define a common Table Format as Object? blackduck603 Word Tables 1 02-20-2009 03:25 PM
Word Format southron_98 Word 0 01-05-2009 07:22 AM
Mail format sachmo21 Outlook 0 09-27-2007 11:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:56 AM.


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