I would like to format a cell with one existing string of numbers into
currency, e.g., the current cell has 123456, and I want to format it so that
it shows 1234.56. When I try to format the cell for currency or accounting,
it changes it to 123456.00, which is the opposite direction in which I want
to move the decimal point. How do I get Excel to move the decimal point two
spaces to the left, instead of two spaces to the right?

Thanks!!!!

This is a dollars and cents question.

In A1 we have
123456
in B1 enter:
=ROUND(A1/100,2)
--
Gary's Student
gsnu200702


"Dos_III" wrote:

I would like to format a cell with one existing string of numbers into
currency, e.g., the current cell has 123456, and I want to format it so that
it shows 1234.56. When I try to format the cell for currency or accounting,
it changes it to 123456.00, which is the opposite direction in which I want
to move the decimal point. How do I get Excel to move the decimal point two
spaces to the left, instead of two spaces to the right?

Thanks!!!!

Enter the number 100 into a cell, copy that cell, select all your other
cells with the values that you want to change, right-click the selection,
choose paste-special / choose "divide" and "values" and click OK

HTH,
Bernie
MS Excel MVP


"Dos_III" wrote in message
...
I would like to format a cell with one existing string of numbers into
currency, e.g., the current cell has 123456, and I want to format it so
that
it shows 1234.56. When I try to format the cell for currency or
accounting,
it changes it to 123456.00, which is the opposite direction in which I
want
to move the decimal point. How do I get Excel to move the decimal point
two
spaces to the left, instead of two spaces to the right?

Thanks!!!!

Formatting changes only the appearance of values, but not the values
themselves. So if you really mean to "make values look like being devided by
hundred" rather than actually deviding them by hundred, you could use a
custom format: #"."##

Cheers,
Joerg Mochikun

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Enter the number 100 into a cell, copy that cell, select all your other
cells with the values that you want to change, right-click the selection,
choose paste-special / choose "divide" and "values" and click OK

HTH,
Bernie
MS Excel MVP


"Dos_III" wrote in message
...
I would like to format a cell with one existing string of numbers into
currency, e.g., the current cell has 123456, and I want to format it so
that
it shows 1234.56. When I try to format the cell for currency or
accounting,
it changes it to 123456.00, which is the opposite direction in which I
want
to move the decimal point. How do I get Excel to move the decimal point
two
spaces to the left, instead of two spaces to the right?

Thanks!!!!