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