View Single Post
  #1   Report Post  
mattslav
 
Posts: n/a
Default 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