inserting decimal two places from the right

[childothe1980s]

Hello:

If you have a number in the cell such as "100" or "25000" or "49" and you
want to place a decimal point two places from the right so that the numbers
read as "1.00" or "250.00" or ".49" respectively, then what Excel formula
would you use?

I tried =LEFT(P2)&"."&RIGHT(P2,2) but the problem with that is that it made
"25000" into "2.00". That's not what I wanted. I wanted "250.00".

Thanks!

childofthe1980s

[davesexcel]

You could just divide the reference by 100

[childothe1980s]

Thanks, Dave!!!

"davesexcel" wrote:

>
> You could just divide the reference by 100
>
>
> --
> davesexcel
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=519016
>
>