Round Question

J

Janet

When using Rounding, how can I show 0's? For example, if I have a number of 12.65, I want to show 13.00. Thanks!
 
K

Kevin Stecyk

Janet,

=ROUND(12.65,0)

And then Format | Cells | Number | Decimal Places 2

Regards,
Kevin



Janet said:
When using Rounding, how can I show 0's? For example, if I have a number
Click to expand...
of 12.65, I want to show 13.00. Thanks!
 
F

Felipe

Janet,

If A1=12.65.
B1=round(A1,0)
Format B1 to show 2 decimals.

Regards,
Felipe
-----Original Message-----
When using Rounding, how can I show 0's? For example, if
Click to expand...
I have a number of 12.65, I want to show 13.00. Thanks!
 
Top