Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
I know this post might be a bit outdated, but still:
has anyone been able to solve this problem?! If so, IŽd be happy, if you could help me here! The solution of Ron Rosenfeld unfortuenately does not work for me. 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? [/i][/color] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
aligning decimal point in a column of figures in Excel | Excel Worksheet Functions | |||
Aligning decimal numers to the centre of the cell and aligning dec | Excel Discussion (Misc queries) | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions |