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