Prev: Duplicates formulaNext: visible cell only From: George Perrotta on 12 Apr 2010 13:12 I have 4 cells that I need to combine into one cell. One cell has a time in it. When I combine cells it does not come up as time but a fraction. A1 8:30 B1 A C1 Cards D1 Indians My formula is =+A1&" "&+B1&" "&+C1&" "&+D1 I get this 0.354166666666667 A Cards Indians I want 8:30 A Cards Indians From: Ron Rosenfeld on 12 Apr 2010 13:49 On Mon, 12 Apr 2010 10:12:56 -0700 (PDT), George Perrotta wrote: >I have 4 cells that I need to combine into one cell. One cell has a >time in it. When I combine cells it does not come up as time but a >fraction. >A1 8:30 >B1 A >C1 Cards >D1 Indians > >My formula is =+A1&" "&+B1&" "&+C1&" "&+D1 >I get this >0.354166666666667 A Cards Indians >I want >8:30 A Cards Indians > > 1. The +'s are redundant, probably a holdover from Lotus123 programming and not required in Excel. 2. =TEXT(A1,"h:mm") & " " & B1 & " " & C1 & " " & D1 Note that in order to obtain 8:30 (with no AM/PM), this is a variation of a 24 hr time format. So that if A1: 2:30 PM, your string will show 14:30. --ron From: tompl on 12 Apr 2010 14:10 Try this: =TEXT(A1,"h:mm")&" "&+B1&" "&+C1&" "&+D1 "George Perrotta" wrote: > I have 4 cells that I need to combine into one cell. One cell has a > time in it. When I combine cells it does not come up as time but a > fraction. > A1 8:30 > B1 A > C1 Cards > D1 Indians > > My formula is =+A1&" "&+B1&" "&+C1&" "&+D1 > I get this > 0.354166666666667 A Cards Indians > I want > 8:30 A Cards Indians > > > > . >  |  Pages: 1 Prev: Duplicates formulaNext: visible cell only