View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Genie Genie is offline
external usenet poster
 
Posts: 6
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?