Forum Discussion

Swayambodh's avatar
Swayambodh
Copper Contributor
Oct 01, 2023

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)
excel
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Oct 01, 2023

Swayambodh 

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" ]

Resources