Inserting a decimal from the right of a string

[MarkM]

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

 

[Roger Govier]

Hi Mark

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

Regards

Roger Govier

 

[JE McGimpsey]

ONe way:

A1: 4577600
A2: =A1/10000

Format A2 with 4 decimal places.

 

[Guest]

Hi

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

Andy.

 

[CLR]

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]

Thanks Roger, Thats what I was looking for.

Hi Mark

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

Regards

Roger Govier

 

[Roger Govier]

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