Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Moving Decimal Places Up
0 views
Skip to first unread message
andyb
May 27, 2005, 11:12:27 AM5/27/05
to
Hi
Type 100 in a blank cell and copy it. Select your range and then Edit|Paste
Special|Divide.
Save a copy before you start!
Type 100 in a blank cell and copy it. Select your range and then Edit|Paste
Special|Divide.
Save a copy before you start!
--
Andy.
"Beth" <Be...@discussions.microsoft.com> wrote in message
news:313FCA19-664D-494E...@microsoft.com...
> Hello everyone,
>
> I have got a list of values e.g. 61025, 68653
>
> I want these to be shown as 610.25, 686.53.
>
> Is there a function that I can use to achieve this?
>
> Regards,
> Beth
Duke Carey
May 27, 2005, 11:16:07 AM5/27/05
to
In an empty cell enter .01. Copy that cell, select all the values you want
to change, use Edit>Paste Special>Multiply
to change, use Edit>Paste Special>Multiply
PCLIVE
May 27, 2005, 11:43:36 AM5/27/05
to
I couldn't get the other suggestions to work correctly as they are using
calculations to move the decimal which will cause some rounding issues,
therefore not giving you what you want. I'm sure they have another
alternative that won't skew the numbers. However, you may try using a
formula.
calculations to move the decimal which will cause some rounding issues,
therefore not giving you what you want. I'm sure they have another
alternative that won't skew the numbers. However, you may try using a
formula.
Assuming your number is in A1.
=LEFT(A1,(LEN(IA1)-2))&"."&RIGHT(A1,2)
If all the numbers are
"Beth" <Be...@discussions.microsoft.com> wrote in message
news:313FCA19-664D-494E...@microsoft.com...
0 new messages