Thread: rounding to .5
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Paul De Winter Jean-Paul De Winter is offline
external usenet poster
 
Posts: 46
Default rounding to .5

Hi,

I want a value like 4.4 to be rounded to 4.5 upon entering
Values like:
6.1 should be 6
4.6 should be 4.5
4.8 should be 5

Any idea?

it should be invoked when leaving the corresponding cell...

Thanks