View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Inserting a decimal from the right of a string

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