View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default formula to BOLD partial number

One simple way

Sub boldleft2()
For Each c In Selection
c.Characters(1, 2).Font.Bold = True
Next
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"israel" wrote in message
...
Helo,

MY experience with your group is awesome. Can you help me with this one,

I have time data "06:09:23" is there a formula where I can indicate the
first two caracters ("06") to be bold. Manually to do this could be quite
a
hassle for a couple of hundred cells.

Thank you

smile