close

but I can do it on some cells. What do I look for to change to be able to do
this since I want a some numbers in a cell string to be bold?

Using Excel 2002.
If you double-click a cell and select part of its content, then
Format|Cells... only displays the Font tab. You can then apply bold to
only a part of the cell.

If you seek some automation that will make parts of the cell string
bold, this will require VBA. Something like:

Range(quot;A1quot;).Characters(Start:=1, Length:=3).Font.FontStyle = quot;Boldquot;
or

Cells(i, j).Characters(Start:=k, Length:=m).Font.FontStyle = quot;Boldquot;

if you are playing with variables.

HTH
Kostis VezeridesIt is hard to tell by how you phrase your question, but if you are talking
about a cell whose contents are entirely numbers, you cannot. I just
experimented, and it did let me bold part of a cell that had only numbers,
but as soon as I left that cell, the bold was removed.

quot;DrBquot; wrote:

gt; but I can do it on some cells. What do I look for to change to be able to do
gt; this since I want a some numbers in a cell string to be bold?
gt;
gt; Using Excel 2002.
gt;
gt;
gt;

No there are couple letters intermixed in the cell.
01/04 17.20/4.35m,-20,-23,S-15.50=4 .

Only one cell was the problem so I copied another and pasted, then corrected
the string. This worked, but still do not know why this was a problem with
one cell. Anyone else know?

quot;Kleevquot; gt; wrote in message
...
gt; It is hard to tell by how you phrase your question, but if you are talking
gt; about a cell whose contents are entirely numbers, you cannot. I just
gt; experimented, and it did let me bold part of a cell that had only numbers,
gt; but as soon as I left that cell, the bold was removed.
gt;
gt; quot;DrBquot; wrote:
gt;
gt;gt; but I can do it on some cells. What do I look for to change to be able to
gt;gt; do
gt;gt; this since I want a some numbers in a cell string to be bold?
gt;gt;
gt;gt; Using Excel 2002.
gt;gt;
gt;gt;
gt;gt;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()