LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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!
 
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 07:23 PM.

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

About Us

"It's about Microsoft Excel"