View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier
 
Posts: n/a
Default How to repalce numbers after a decimal

Format-Cells-Number tab-Click 'Custom', and enter this:

0.95


--
Regards,
Dave


"dpscoupe" wrote:

Lets say I have a column of numbers, that looks like this:

10.242
11.817
12.915
14.805

and I want it to look like this:

10.95
11.95
12.95
14.95

What function could be used to accomplish this?