How can I make a whole number
 

I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer
to be 263.81. I know I can format the cell to only show 2 decimal places, but
that is not what I need. I would like on only have the number 263.81 so if I
need to use that number to calculate some where else, it will not use the
rounded number of 263.8125, but the whole number of 263.81

Does that make since

How can I make a whole number
 

=ROUND(A1,2)

"sbhayes" wrote:

I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer
to be 263.81. I know I can format the cell to only show 2 decimal places, but
that is not what I need. I would like on only have the number 263.81 so if I
need to use that number to calculate some where else, it will not use the
rounded number of 263.8125, but the whole number of 263.81

Does that make since

How can I make a whole number
 

Try something like this:

=ROUND(23.45*11.25,2)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"sbhayes" wrote:

I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer
to be 263.81. I know I can format the cell to only show 2 decimal places, but
that is not what I need. I would like on only have the number 263.81 so if I
need to use that number to calculate some where else, it will not use the
rounded number of 263.8125, but the whole number of 263.81

Does that make since

How can I make a whole number
 

=ROUND(A1,2)

Please post to one group only.

"sbhayes" wrote:

I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer
to be 263.81. I know I can format the cell to only show 2 decimal places, but
that is not what I need. I would like on only have the number 263.81 so if I
need to use that number to calculate some where else, it will not use the
rounded number of 263.8125, but the whole number of 263.81

Does that make since

How can I make a whole number
 

Hi

Use this formula:
=ROUND(23.45*11.25,2)
to round the result to 2 decimal places.

Hope this helps.
Andy.

"sbhayes" wrote in message
...
I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer
to be 263.81. I know I can format the cell to only show 2 decimal places,
but
that is not what I need. I would like on only have the number 263.81 so if
I
need to use that number to calculate some where else, it will not use the
rounded number of 263.8125, but the whole number of 263.81

Does that make since

How can I make a whole number
 

My apologies ... I was flicking between groups so thought you had postd to
another NG

"Toppers" wrote:

=ROUND(A1,2)

Please post to one group only.

"sbhayes" wrote:

I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer
to be 263.81. I know I can format the cell to only show 2 decimal places, but
that is not what I need. I would like on only have the number 263.81 so if I
need to use that number to calculate some where else, it will not use the
rounded number of 263.8125, but the whole number of 263.81

Does that make since

How can I make a whole number
 

Thank you the Round worked GREAT!!!!!

"Toppers" wrote:

=ROUND(A1,2)

"sbhayes" wrote:

I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer
to be 263.81. I know I can format the cell to only show 2 decimal places, but
that is not what I need. I would like on only have the number 263.81 so if I
need to use that number to calculate some where else, it will not use the
rounded number of 263.8125, but the whole number of 263.81

Does that make since