G Guest Oct 23, 2003 #1 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!
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 Oct 23, 2003 #2 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!
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 Oct 24, 2003 #3 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!
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!
