Format last three digits of a cell to appear in bold?

[kznmrexcel]

Hi, everyone,
Is there a way to format *part* of a cell to appear in bold? I'm thinking not, but thought I'd ask.

Example:
1234567

I would imagine that I would need a workaround, such as grabbing the last three digits and having them appear in a separate column which I could then bold.

Any help is appreciated.
Thanks,
Karen

 

[Fluff]

Don't think you can do that with numbers, but you could use

=RIGHT(A2,3)

to get the last 3 characters in another cell.

 

[kznmrexcel]

That's what I was thinking. Thank you for posting!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[kevin9999]

If this is something you're doing purely for aesthetic reasons, and VBA is an option for you, then the following should give you what you want. Assumes your data starts in A1 (you can amend the range definition to suit your needs).

Option Explicit
Sub BoldLast3()
    Dim c As Range, rng As Range, i As Long
    Set rng = Range("A1").CurrentRegion
    For Each c In rng
        c = "'" & c
        For i = (Len(c) - 2) To Len(c)
            c.Characters(i).Font.Bold = True
        Next i
    Next c
End Sub

 

[Fluff]

One potential problem with that, is it converts the number into text, which could cause the OP problems.

 

[kevin9999]

One potential problem with that, is it converts the number into text, which could cause the OP problems.

That's true @Fluff, hence my "aesthetic" comment, although when testing I note that simple arithmetic formulas that reference the affected cells remain correct after running the code. Good point though.