View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default using round to increase decimal ?

On Mon, 20 Sep 2004 14:51:03 -0700, "rania"
wrote:

fhi

I would like to increase decimal using round function instead of Format .
for example Ihave 422, and would like 422.00 to be schown.

I know that it does not make since because of the function of round.
but I have this in an excercice .

Thanks


The ROUND function cannot cause 422 to be displayed as 422.00

It could turn 422.004763 into 422.00


--ron