View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sbhayes sbhayes is offline
external usenet poster
 
Posts: 11
Default 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