# How can we reduce the font size of decimal value ? How can we reduce the font size of Decimal Value in excel? (Just like its shown in image)

6 Replies

# Re: How can we reduce the font size of decimal value ?

It is impossible to do that with numbers.

It would be possible if you converted the number to a text value, but that would cause problems with calculations: # Re: How can we reduce the font size of decimal value ?

Many things are possible  That is not to say they are worth doing!  For example, you could commit separate columns for dollars and cents and format each as you like. summing the column would require a bit of effort though.

``````Sum2Partsλ(amount)
= LET(
values, TAKE(twoCol, , 1) + ROUND(TAKE(twoCol, , -1) / 100, 2),
result, SUM(values),
HSTACK(INT(result), ROUND(100 * (result - INT(result)), 0))
)``````

[ Note: the integer cents are formatted using the number format "\.00" ]

# Re: How can we reduce the font size of decimal value ?

Alternatively, you could do it with VBA without having to convert it to text.

Attached is an example file.

# Re: How can we reduce the font size of decimal value ?

Niko, please note that the values in your sample workbook are text values. They are left-aligned while horizontal alignment is set to General, and the formula =SUM(A1:A3) returns 0.

If I convert the values to numbers, your macro has no effect.

# Re: How can we reduce the font size of decimal value ?

You're absolutely right, my mistake. Too focused on the point and not on the task. I apologize for the confusion. Adjusting the font size for certain parts of the number is not a built-in function in Excel's VBA, or is there a way?...to do this with VBA.

# Re: How can we reduce the font size of decimal value ?

It is not possible to format part of a number, date or TRUE/FALSE value differently from the rest, only of text values. And if a cell contains a formula, it is not possible at all, regardless of the data type of the return value.