How to make the decimal part of a number smaller

hello everyone i want to make decimal number small in font size in excell for example: 123,456 : the number 456 i want to make them look smaller in size in excell please help.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

What you want to do cannot even be done manually, so I think it very unlikely indeed that it can be done with VBA, which would be your only other option.

I disagree. I'm pretty sure this can be done -- as long as the "number" is stored in the cell as a text literal. The most common scenario is where one wants to add a superscript/subscript character to a number value in Excel, but this should work for font size as well.

1) Enter the number into a cell as a text literal. If hand entering the number, you can simply add a leading apostrophe to the number to indicate text, or preformat the cell as text, or any other strategy you like for entering numbers as text. Note that you cannot simply use the TEXT() function, because none of this works on a cell containing a formula -- it only works on a cell containing a text literal. If you use VBA to do the number to text conversion, note that you will need to be extra careful when VBA writes the text to a cell, because VBA/Excel are going to strongly want to convert the text back to a number.
2) Select the desired characters (manually: F2 to enter edit mode, then select the desired characters using shift+arrow keys or the mouse. VBA: use the Characters property https://docs.microsoft.com/en-us/off...nge.Characters ) and change the font size of the desired characters.

You end up with a cell containing a number stored as text, with all of the problems and limitations that come with numbers stored as text. If this is a final calculation, then it will probably be fine. If this is an intermediate calculation and you will still need to use the number, you will probably want to do this kind of formatting on a copy of the number that won't be used in other calculations.

If your number is in A1 then this will change the colour, size and bolden the text after the last comma.

A1 is formatted as text so multiply by 1 before using it in any formulas.

Please Login or Register  to view this content.

@Hamibou, maybe this is what you are looking for.

With a small addition to the code of mehmetcik, you can get you "superscript":

Please Login or Register  to view this content.

Cheers
Erwin