LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Trey
 
Posts: n/a
Default Formatting inconsistencies using the comma button


Hi --

All I want to do is consistently be able to sum up a column of numbers into
a cell and throw commas onto the summed number and still have it centered
like the rest of the column. I can get it to work sometimes -- but other
times -- after I use the comma button -- the sum number right-justifies
automatically and I can't center it. I can't see why one document will allow
me to center the comma'd number while the other won't. These are plain
numbers -- not monetary values.

Thanks in advance for your help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Button anomalies RWN Excel Discussion (Misc queries) 5 May 4th 05 05:09 AM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
Cell formatting behaviour question derek Excel Discussion (Misc queries) 3 February 22nd 05 10:17 PM
Pivot Table not valid error message when formatting data 'button'. MDW Excel Discussion (Misc queries) 0 January 27th 05 03:01 PM
Macro to simply bring up the Find dialogue box?? marika1981 Excel Discussion (Misc queries) 14 January 14th 05 10:47 PM


All times are GMT +1. The time now is 04:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"