Converting a number to 2 decimal places
 

I would like to be able to type a number into a cell and have it
automatically converted to a number with the last 2 numbers to the
right of the decimal point. For example, if I typed in 1234, it would
become 12.34. How can I do that?


--
mattslav
------------------------------------------------------------------------
mattslav's Profile: http://www.excelforum.com/member.php...o&userid=24039
View this thread: http://www.excelforum.com/showthread...hreadid=376481

ToolsOptionsEdit
Check Fixed decimal places
Set for 2

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=376481

Yes, that is exactly what I want. Thanks.


--
mattslav
------------------------------------------------------------------------
mattslav's Profile: http://www.excelforum.com/member.php...o&userid=24039
View this thread: http://www.excelforum.com/showthread...hreadid=376481