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

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" 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