Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I align table cells on the basis of decimal point

I would like to be able to align numbers in table cells on the basis of the
decimal point. I thought I did this once before (many years ago) but cannot
see how to do it in Office 2007 applications.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default How can I align table cells on the basis of decimal point

When you say "Office", do you mean Excel, Word or something else? If it's
not Excel, you should post to the appropriate group. If it's Excel, you need
to tell us what format you are using, because decimals should be easy to
line up.

Regards,
Fred.

"Mike_Clancy" wrote in message
...
I would like to be able to align numbers in table cells on the basis of the
decimal point. I thought I did this once before (many years ago) but
cannot
see how to do it in Office 2007 applications.


  #3   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 94
Default How can I align table cells on the basis of decimal point

Mike,
can you do a search under this discussion group.
I think there are some solutions already provided.
one solution that might help would be
=A1& REPT(" ", 5 + FIND(".", A1) - LEN(A1))

let me know if you can't find what your looking for?

-kc
*click YES if this helps

"Mike_Clancy" wrote:

I would like to be able to align numbers in table cells on the basis of the
decimal point. I thought I did this once before (many years ago) but cannot
see how to do it in Office 2007 applications.

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 center numbers in a cell, but align by decimal? Juliue Excel Discussion (Misc queries) 2 January 28th 09 11:55 PM
Decimal point David New Users to Excel 3 July 26th 06 05:02 PM
can not find align decimal points option Rae Drysdale Excel Discussion (Misc queries) 3 April 27th 06 09:47 PM
Converting 2-place decimal value to floating point decimal number with leading zero Kermit Piper Excel Discussion (Misc queries) 3 March 18th 06 06:20 PM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. SUKYKITTY Excel Discussion (Misc queries) 3 July 6th 05 01:50 PM


All times are GMT +1. The time now is 11:19 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"