Formulas can't return this kind of formatting.

You'll either have to do it some other way.

Copy|paste special|formats
format|cells|alignment tab

You could use a macro that does the work, but that still won't be a formula.

JonatanRaven wrote:

Dave Peterson Wrote:
Just format the cells (format|cells|alignment tab)???

Dave Peterson

Yes, I solved that one, but the reference to another worksheet I can't
get to work, any ideas..?

--
JonatanRaven

------------------------------------------------------------------------
JonatanRaven's Profile: http://www.excelforum.com/member.php...o&userid=30425
View this thread: http://www.excelforum.com/showthread...hreadid=500929

--

Dave Peterson