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