Inserting a decimal from the right of a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation a character in a string 1
Cut the last 20 characters out of a text string 4
Inserting decimal 6
Excel Extract Text from decimal separated string 6
I need help insert a decimal other then directly to the right of t 1
insert "-" as fourth character in number string 2
Insert spaces in text string in Excel 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top