Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 11th 05, 04:56 PM
notloiseweiss
 
Posts: n/a
Default 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   Report Post  
Old November 11th 05, 06:32 PM
MrShorty
 
Posts: n/a
Default 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   Report Post  
Old November 11th 05, 06:55 PM
notloiseweiss
 
Posts: n/a
Default 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   Report Post  
Old November 11th 05, 10:17 PM
MrShorty
 
Posts: n/a
Default 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
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
How do I select multiple data points on my chart? Matthew S Charts and Charting in Excel 1 September 13th 05 06:38 PM
convert imported data with . separator for decimal into , separato kris Excel Discussion (Misc queries) 1 September 8th 05 11:34 PM
Leading Zeros and decimal points Sam Excel Worksheet Functions 3 July 12th 05 12:40 PM
Decimal points not needed Paul K. Excel Worksheet Functions 1 June 3rd 05 02:51 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017