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 advance

Hi Mark

=LEFT(A1,LEN(A1)-4)&"."&RIGHT(A1,4)

Regards

Roger Govier


MarkM wrote:
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 advance

Thanks Roger, Thats what I was looking for.

"Roger Govier" wrote:

Hi Mark

=LEFT(A1,LEN(A1)-4)&"."&RIGHT(A1,4)

Regards

Roger Govier


MarkM wrote:
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 advance

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 Govier


MarkM wrote:
Thanks Roger, Thats what I was looking for.

"Roger Govier" wrote:


Hi Mark

=LEFT(A1,LEN(A1)-4)&"."&RIGHT(A1,4)

Regards

Roger Govier


MarkM wrote:

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 advance

ONe way:

A1: 4577600
A2: =A1/10000

Format A2 with 4 decimal places.


In article ,
"MarkM" wrote:

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 advance

Hi

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

Andy.

"MarkM" wrote in message
...
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 advance

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 PasteSpecial Divide..........

Vaya con Dios,
Chuck, CABGx3




"MarkM" wrote:

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 advance