Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I center numbers in a cell, but align by decimal? | Excel Discussion (Misc queries) | |||
Decimal point | New Users to Excel | |||
can not find align decimal points option | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |