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.
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("A1").Characters(Start:=1, Length:=3).Font.FontStyle = "Bold"
or
Cells(i, j).Characters(Start:=k, Length:=m).Font.FontStyle = "Bold"
if you are playing with variables.
HTH
Kostis Vezerides
It 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.
"DrB" wrote:
> 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.
>
>
>
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?
"Kleev" <[email protected]> wrote in message
news:[email protected]...
> It 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.
>
> "DrB" wrote:
>
>> 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.
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks