View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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