Copy parts of a number
On Sat, 5 Jun 2010 00:14:26 -0700, GeniE
wrote:
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?
What are your settings for the "decimal point". If it is a comma,
then:
=round(a1,2) or =round(a1;2) depending on your separator.
If it is really a text string, then
=LEFT(A1,FIND(",",A1)+2)
|