MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formating in Excel 97

Posted by R. Karlsen on November 22, 2000 2:03 PM

I have a question about formatting in Excel 97:
My problem is, ( numbers is examples:)

Cell A: 225, Cell B:333, then Sum of A3*B3 ( in C3) is 558, then I want to format the result something like this: 5"58",
yes, the last two digits with a different color, and / or as bold characters.

PS. The result ( C3 ), is sometimes with four, five, six, and more characters.

Any suggestions?

Posted by AARON on November 24, 2000 3:11 PM

Enter a custom cell format as #"##" using 2 single quotation marks to represent the doube quotation marks. Change this to
#"00" if two digits are a must (it would display 3 as "03").As far as changing the format of only the last two digits, the
only I can think do that would be to seperate them into a seperate column.