Home |
Search |
Today's Posts |
|
#1
![]()
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) |