Formatting part of text

[Guest]

I have text in a cell, and I want to format part of it (one word) with a
strike-through font. I selected the word and right clicked, clicked Format
cells, and selected the Strike-through box. While I'm in the edit mode for
that cell, I can see the formatting, but when I click Enter or move to
another cell, the strike-through disappears and only the defaulf format
shows.

I have had the same problem when I've tried to used colored text or
underlining in part of a cell. But I know it's possible to format part of a
cell, because I've done it on other worksheets!

Does anyone know what I might be missing?

 

[stevebriz]

Click on the cell then in the bar at the top that shows what is in the
cell
highlight with mouse the 3 part of the text you want to change then
Rightclick ( where the text is highlighted)and choose strikethrough.

 

[Guest]

Be sure to either double-click in the cell or single-click in the formula bar
and tehn select the part of the text to be re-formatted.

 

[Guest]

That's what I did. As long as I'm in edit mode I can see the change, but
when I click Enter or move to another cell, the format doesn't show up.

Is there some setting that allows you to see partial formats?

 

[Dave Peterson]

Is the value in the cell text or a formula (or even a number)?

This kind of character by character formatting only works with text.

So you couldn't use a strikethrough font for just "hello" in the following
formula:
="Hello from us on " & text(today(),"mm/dd/yyyy")

 

[Guest]

No, it's only text. No numbers, formulas or functions.

 

[Dave Peterson]

Do you have any event macros running in the background?

If you open the workbook with macros disabled, does it work ok?

 

[Guest]

I think I may have solved it myself -- I changed the number format from
Accounting (my default) to General, and now it works. That would explain why
it worked on other people's spreadsheets, because they still had the General
number default.

 

[Dave Peterson]

Oooh.

I think someone else posted that same problem/solution a few weeks ago. But I
had forgotten it.

Thanks for posting back. Now Google has it for anyone who looks there!

I think I may have solved it myself -- I changed the number format from
Accounting (my default) to General, and now it works. That would explain why
it worked on other people's spreadsheets, because they still had the General
number default.