Steved said:
Please my objective is as set out below
547 to become 5.47
600 to become 6.00
912 to become 9.12 and so on how do I acheive this
I think your question is unclear.
First, it is unclear whether 547 etc are text or numbers.
Be careful: looks can be deceiving. If 547 is in A1, what is the result of
=TYPE(A1) in another cell: 1 or 2?
If 547 etc are text, do you want 5.47 etc to be text or numbers?
Second, it is unclear whether you want 547 etc to simply __appear__ as 5.47
etc, or if you want their values to be changed to 5.47 etc.
Finally, it is unclear whether you want those changes to occur in the cells
that current contain 547 etc, or if you want 5.47 etc in another set of
cells.
If 547 etc are numbers and you just want to change their appearance in the
same cells, you could use the custom format "0\.00" without quotes.
If 547 are numbers or text, and you want the numbers 5.47 etc in the same
cells, you could put 100 in an unused cell and copy it, then highlight the
cells with 547 etc, and click Edit > Paste Special > Divide > OK (in Excel
2003).
