View Single Post
  #1  
Old June 5th, 2010, 08:14 AM posted to microsoft.public.excel.misc
Genie
external usenet poster
 
Posts: 10
Default Copy parts of a number

If I have a cell with a digit 123,4567 - how can I copy the content of the
cell to another cell with only two digits after the comma. In other words - I
only want 123,45 to appear in the new cell.

Is there any way to use a "round off" functionality?