Indent formatted cell

D

Deborah

I would like cells that are formatted with comma (no
decimals) to be indented.
I can do it to non-formatted cells, but once I apply the
currency or comma style, I can no longer indent the cells.
I wish to do this to line them up closer to the centre and
thus under the heading at the top.

Thank you
Deborah
 
D

Dave O

Hi, Deborah-
You don't specify what your comma format cells look like so I don't
know if this will work. How about if you leave the cell unformatted,
and achieve the comma formatting with the TEXT() function. Then you
can apply the indent to the cell.

Hope this does it for you-
Dave O
 
Top