Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DrB
 
Posts: n/a
Default bold part of cell unavailable at time

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.


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default bold part of cell unavailable at time

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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kleev
 
Posts: n/a
Default bold part of cell unavailable at time

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.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DrB
 
Posts: n/a
Default bold part of cell unavailable at time

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" wrote in message
...
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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 08:21 PM
How do I get one cell to record the time another cell was changed. Reigning in Seattle Excel Discussion (Misc queries) 1 December 17th 04 07:45 PM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 02:48 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 12:07 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 12:07 AM


All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"