Hello from Steved

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

Put 100 in an unused cell
Edit|copy that cell

Select the range to adjust
Edit|paste special|click Divide and Values

Clean up that cell that you put the 100 in.

Steved wrote:

Hello from Steved

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

--

Dave Peterson

Hi,

Type 100 in a cell. Copy the cell and then select the range of numbers.
Goto Edit paste special Divide.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Steved" wrote in message
...
Hello from Steved

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

"Steved" wrote:
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).