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" <(E-Mail Removed)> wrote in message
news:9B59BAC2-68E9-4FA1-A17E-(E-Mail Removed)...
> 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?
|