Thread: Format cell to specific number style

Nevermind, I saw that I divided the C1 by 100. DUH!


Hi,

This may seem so simple, but I can't figure this out.

A1 B1 C1
350 x 78.5 = 27475

problem is that the C1 shows 274.75. With zero decimal it rounds to 275

I need to C1 to display 27475 with two decimal places (27475.00)


Any ideas?

George

try for cell c1
select columm C and from main meniu, cell format, number, decimal places 2, ok.
see if it helps you!

Hi George,

Format the result cell i.e., C1 as Number with Two Decimal, see attached. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

Hi,
Are you sure that either A or B is not actually a percentage?