Prev: No formulas Work
Next: Where is the number lock key on my HP Pavilion zv 6000???????????
From: GeniE on 5 Jun 2010 03:14
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?
From: L. Howard Kittle on 5 Jun 2010 03:30
Well, I wonder if it is really a 'number'...?

Seems to be text as written and if 123,4567 copied and pasted from the post
to Excel it shows as 1,234,567.

So pasted in a text formatted cell you can use =LEFT(A1,6) to return 123,45.

HTH
Regards,
Howard

"GeniE" <GeniE(a)discussions.microsoft.com> wrote in message
news:9B59BAC2-68E9-4FA1-A17E-F76E734C3B4C(a)microsoft.com...
> 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?


From: Ron Rosenfeld on 5 Jun 2010 07:36
On Sat, 5 Jun 2010 00:14:26 -0700, GeniE
<GeniE(a)discussions.microsoft.com> 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)

 | 
Pages: 1
Prev: No formulas Work
Next: Where is the number lock key on my HP Pavilion zv 6000???????????