software

How can I insert a decimal into a number? I need to insert this before the
fourth character in the string from the right? I cannot insert this from the
left of the string because the number of characters in the sting to the left
can vary.

For example:
I need to change 4577600 to 457.7600

Thanks in advanceHi Mark

=LEFT(A1,LEN(A1)-4)amp;quot;.quot;amp;RIGHT(A1,4)

Regards

Roger GovierMarkM wrote:
gt; How can I insert a decimal into a number? I need to insert this before the
gt; fourth character in the string from the right? I cannot insert this from the
gt; left of the string because the number of characters in the sting to the left
gt; can vary.
gt;
gt; For example:
gt; I need to change 4577600 to 457.7600
gt;
gt; Thanks in advance
gt;

ONe way:

A1: 4577600
A2: =A1/10000

Format A2 with 4 decimal places.In article gt;,
quot;MarkMquot; gt; wrote:

gt; How can I insert a decimal into a number? I need to insert this before the
gt; fourth character in the string from the right? I cannot insert this from the
gt; left of the string because the number of characters in the sting to the left
gt; can vary.
gt;
gt; For example:
gt; I need to change 4577600 to 457.7600
gt;
gt; Thanks in advance

Hi

Can't you just divide the number by 10,000?

Andy.

quot;MarkMquot; gt; wrote in message
...
gt; How can I insert a decimal into a number? I need to insert this before
gt; the
gt; fourth character in the string from the right? I cannot insert this from
gt; the
gt; left of the string because the number of characters in the sting to the
gt; left
gt; can vary.
gt;
gt; For example:
gt; I need to change 4577600 to 457.7600
gt;
gt; Thanks in advance
gt;
type 10000 in an unused cell , left click on it and choose COPY
then highlight all the cells you wish to change,
then right-click gt; PasteSpecial gt; Divide..........

Vaya con Dios,
Chuck, CABGx3

quot;MarkMquot; wrote:

gt; How can I insert a decimal into a number? I need to insert this before the
gt; fourth character in the string from the right? I cannot insert this from the
gt; left of the string because the number of characters in the sting to the left
gt; can vary.
gt;
gt; For example:
gt; I need to change 4577600 to 457.7600
gt;
gt; Thanks in advance
gt;

Thanks Roger, Thats what I was looking for.

quot;Roger Govierquot; wrote:

gt; Hi Mark
gt;
gt; =LEFT(A1,LEN(A1)-4)amp;quot;.quot;amp;RIGHT(A1,4)
gt;
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; MarkM wrote:
gt; gt; How can I insert a decimal into a number? I need to insert this before the
gt; gt; fourth character in the string from the right? I cannot insert this from the
gt; gt; left of the string because the number of characters in the sting to the left
gt; gt; can vary.
gt; gt;
gt; gt; For example:
gt; gt; I need to change 4577600 to 457.7600
gt; gt;
gt; gt; Thanks in advance
gt; gt;
gt;

Hi Mark

Please note the formula i gave you will produce text, which is what I
presumed you wanted.
I can see from other responses, they all interpreted your question as still
requiring numerics, in which case each of the other responses received will
do that perfectly and you should go with one of those solutions.

Regards

Roger GovierMarkM wrote:
gt; Thanks Roger, Thats what I was looking for.
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;
gt;gt;Hi Mark
gt;gt;
gt;gt;=LEFT(A1,LEN(A1)-4)amp;quot;.quot;amp;RIGHT(A1,4)
gt;gt;
gt;gt;Regards
gt;gt;
gt;gt;Roger Govier
gt;gt;
gt;gt;
gt;gt;MarkM wrote:
gt;gt;
gt;gt;gt;How can I insert a decimal into a number? I need to insert this before the
gt;gt;gt;fourth character in the string from the right? I cannot insert this from the
gt;gt;gt;left of the string because the number of characters in the sting to the left
gt;gt;gt;can vary.
gt;gt;gt;
gt;gt;gt;For example:
gt;gt;gt;I need to change 4577600 to 457.7600
gt;gt;gt;
gt;gt;gt;Thanks in advance
gt;gt;gt;
gt;gt;