inserting decimal two places from the right
 

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

inserting decimal two places from the right
 

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

inserting decimal two places from the right
 

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