Thread: How do I show (.50) on in an Excel column-it keeps coming up (.5)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default How do I show (.50) on in an Excel column-it keeps coming up (.5)
Format the cells as Number with 2 decimal places.

Hope this helps.

Pete

On Oct 19, 7:34*pm, fnarkie wrote:
I am trying to add figures on Excel-instead of 1/2 I am trying to use .50-but
it keeps coming up .5-How can I get the 0 in after the 5

Reply With QuoteReply With Quote