Substitute to Retun a number clb 12/31/2008 4:46:07 PM I am using the substitute function to split a cell containing <5 into two cells: < and 5 using the following =substitute (A1,"<","") I need the 5 to be a number and this is causing it to be formatted as text. Any suggestions? Thanks in advance!

Re: Substitute to Retun a number "T. Valko" <biffinpitt[ at ]comcast.net> 12/31/2008 4:54:58 PM Try this: =--SUBSTITUTE(A1,"<","") -- Biff Microsoft Excel MVP "clb" <yoursisplayname[ at ]discussions.microsoft.com> wrote in message news:D0944E99-F24A-42D1-ABCC-BEC1171B6C30[ at ]microsoft.com... [Quoted Text] >I am using the substitute function to split a cell containing <5 into two > cells: < and 5 using the following > > =substitute (A1,"<","") > > I need the 5 to be a number and this is causing it to be formatted as > text. > Any suggestions? Thanks in advance!

RE: Substitute to Retun a number Gary''s Student 12/31/2008 4:55:01 PM =--SUBSTITUTE(A1,"<","") -- Gary''s Student - gsnu200823