View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DianaC DianaC is offline
external usenet poster
 
Posts: 1
Default Change number from multiple decimals to 2

Can someone please help me figure out how to change a number that has
multiple declimal places (example 54.123456) to only 2 places (example
54.12). When I format the number to 2 decimals, it appears correct, however,
when I "click" on the number, it still shows the multiple decimals. I need
the number to only show 2 decimal places at all times. Any suggestions would
be greatly appreciated!
--
Diana