Change 805 to time as 0805?

[Captain Randy]

I have data in colum B as text, I want to change it too hhmm as 0100 and not 100.

Format cells dosen't work, it takes 805 and makes it read as 0:00.

Is there a way I can change this to end up with hh:mm ? 0001 too 2400.

Thank you in advance

 

[sanrv1f]

try one of these

Excel Workbook
	A	B	C
1	0001	00:01	00:01
2	0024	00:24	00:24
3	0145	01:45	01:45
4	0505	05:05	05:05
5	2300	23:00	23:00
Sheet1

Excel 2003

Cell Formulas
Range	Formula
B1	=(LEFT(A1,2)&":"&RIGHT(A1,2))+0
C1	=TEXT(A1,"00\:00")+0

 

[Captain Randy]

Thank You very much Sanrv1f !!!!
The Text worked great ......

Once again Thank You !!!
Captain Randy
<TABLE style="WIDTH: 119pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=158><COLGROUP><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5056" width=158><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 119pt; HEIGHT: 15.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl63 height=21 width=158 align=right>

</TD></TR></TBODY></TABLE>