View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Melissa Melissa is offline
external usenet poster
 
Posts: 122
Default aligning by decimal point - negative and positive numbers

I am trying to align my columns by decimal point. I have both negative and
positive numbers, as well as asterisks (to show statistical significance) and
so using Format|Cells|Number and trying the number, currency, and accounting
options don't seem to work, nor does the custom option when I try ##.???? or
-#.????.

For example, I have the following numbers I want to line up:
-0.2684***
-0.2602***
0.7165**
1.0023

Any suggestions?