Aligning decimals in Excel ...

G

Guest

How can I align decimals other than using right justify in Excel 2000? I
prefer the numbers to appear centered within the column, but with the
decimals in alignment. The Center tool only gives me the former. All
numbers have only one decimal place, but have various digits before the
decimal.
 
R

RagDyeR

First, center the column, then play with the question marks to display
exactly what you're looking for.

You can start with this custom format, then revise to suit:

?,???,???.0??
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


How can I align decimals other than using right justify in Excel 2000? I
prefer the numbers to appear centered within the column, but with the
decimals in alignment. The Center tool only gives me the former. All
numbers have only one decimal place, but have various digits before the
decimal.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I align decimals in Excel when not all numbers have % sym. 2
Summing large numbers with decimals in Excel 1
Aligning data with varying decimal places 1
alignment with decimals & % sign 6
Cell displays #'s incorrectly 3
align numbers with comma and center within column 3
decimals do not line up in column formatted the same 6
How To Align Decimals In A PP 2007 Table 3

Top