Thanks for your help. I found out that the problem was with the number
format of the cell. I often format an entire spreadsheet with a comma
format. This prevented the text within a cell from being formatted as
I wanted. When I change the number format of the cell to general, the
format of the text changes appropriately.


--
gailann
------------------------------------------------------------------------
gailann's Profile: http://www.excelforum.com/member.php...o&userid=30798
View this thread: http://www.excelforum.com/showthread...hreadid=504592