LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

And it works with non-proportional fonts, too.

To the OP, maybe using Bernie's idea...Something like:
?,???.???
would work ok for you.

Bernie Deitrick wrote:

bacai,

From help:

? adds spaces for insignificant zeros on either side of the decimal point so
that decimal points align when formatted with a fixed-width font, such as
Courier New.

To display Use
this code
44.398, 102.65, and 2.8 with aligned decimals ???.???

I'm guessing that commas can be aligned in a similar manner.

HTH,
Bernie
MS Excel MVP

"bacai" wrote in message
...
I am running Excel 2002 on XP.

I have a wide column and all the numbers in the column are six or less
digits. I would like to center the numbers and have them comma align. How
would this be accomplished?

All help appreciated


--

Dave Peterson
 
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
Align $ sign next to numbers Christina Excel Discussion (Misc queries) 5 April 7th 05 07:21 PM
Match Last Occurrence of two numbers and Return Date Sam via OfficeKB.com Excel Worksheet Functions 6 April 5th 05 12:40 PM
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM
Count and Sum Total occurrances of two specific numbers Sam via OfficeKB.com Excel Worksheet Functions 10 March 29th 05 08:13 PM
Converting Numbers to Text properly Shirley Munro Excel Discussion (Misc queries) 1 February 16th 05 03:01 PM


All times are GMT +1. The time now is 10:49 PM.

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"