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
|