Thread: How do I show (.50) on in an Excel column-it keeps coming up (.5)
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default How do I show (.50) on in an Excel column-it keeps coming up (
Select the cell, goto menu FormatCells, and on the Number tab, select the
Number category, and set it there.

--
__________________________________
HTH

Bob

"fnarkie" wrote in message
...


"Pete_UK" wrote:

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

Can u explain the solution more clearly-sorry I'm new at this


Reply With QuoteReply With Quote