ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem with partial-cell font formatting (https://www.excelbanter.com/excel-discussion-misc-queries/168976-problem-partial-cell-font-formatting.html)

Eric

Problem with partial-cell font formatting
 
I'm puzzled.

In Excel 2003, I have a cell containing text of about 50 characters. The
first 30 or so are in black, and I've applied manual formatting to the
right-most 20 characters so that they're red. When I select the cell and hit
F2 (edit), I can see the red formatting that I applied. But when I hit
Enter, the red formatting disappears and the entire contents of the cell are
black.

There's no conditional formatting on the cell.

Any idea what's happening, or how to fix it??

Thanks.

Bernard Liengme

Problem with partial-cell font formatting
 
I cannot reproduce this in XL 2003
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Eric" wrote in message
...
I'm puzzled.

In Excel 2003, I have a cell containing text of about 50 characters. The
first 30 or so are in black, and I've applied manual formatting to the
right-most 20 characters so that they're red. When I select the cell and
hit
F2 (edit), I can see the red formatting that I applied. But when I hit
Enter, the red formatting disappears and the entire contents of the cell
are
black.

There's no conditional formatting on the cell.

Any idea what's happening, or how to fix it??

Thanks.




Dave Peterson

Problem with partial-cell font formatting
 
Make sure your cell is formatted as Text or General.

I bet that cell is formatted as Accounting.

Eric wrote:

I'm puzzled.

In Excel 2003, I have a cell containing text of about 50 characters. The
first 30 or so are in black, and I've applied manual formatting to the
right-most 20 characters so that they're red. When I select the cell and hit
F2 (edit), I can see the red formatting that I applied. But when I hit
Enter, the red formatting disappears and the entire contents of the cell are
black.

There's no conditional formatting on the cell.

Any idea what's happening, or how to fix it??

Thanks.


--

Dave Peterson


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com