Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Aligning Decimal Points with non-numeric data
I am creating a table and would like to align my data by the decimal point.
I understand that the accounting format will do this, however my data sometimes includes symbols. For example 1.23 7.94 8.45** (3.12) 5.88 The accounting format seems to deal well with the (3.12), but I can't get the decimal places to align for the 8.45**. Any advice??? Also the accounting format won't allow me to indent. Thanks in advance! |
#2
|
|||
|
|||
Aligning Decimal Points with non-numeric data
This format code (Format-Cells-Number tab-Custom) seems to work for me. 0.00_*_*_);(0.00)_*_*;0.00_*_*_);@_) Make sure the alignment is set to right. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=484328 |
#3
|
|||
|
|||
Aligning Decimal Points with non-numeric data
Thanks for the idea MrShorty.
But, your solution doesn't seem to work for the 7.94** ??? Here's my actual data: 7.94** (139.63) 10.47 18.18 (7.87) "MrShorty" wrote: This format code (Format-Cells-Number tab-Custom) seems to work for me. 0.00_*_*_);(0.00)_*_*;0.00_*_*_);@_) Make sure the alignment is set to right. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=484328 |
#4
|
|||
|
|||
Aligning Decimal Points with non-numeric data
In what way didn't it work? It works for me, including the 7.94**. Did you set the horizontal alignment to "right?" General alignment puts text values (like 7.94**) left justified with numbers right justified. You want everything (text or number) right justified. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=484328 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select multiple data points on my chart? | Charts and Charting in Excel | |||
convert imported data with . separator for decimal into , separato | Excel Discussion (Misc queries) | |||
Leading Zeros and decimal points | Excel Worksheet Functions | |||
Decimal points not needed | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel |