My formulas return the formula not a result in the cell

[1stcoast]

Cell A1
Formula in cell B1
00-1-36000-21800 SPPNT HUGGIES GOODNITES =LEFT(A2,16)

The calculation returns the formula not a result. What am I doing wrong?

[daddylonglegs]

B1 is probably formatted as text

this should fix it
select B1
Edit > Replace
Replace = with =

[1stcoast]

Thanks your solution fixed the problem.

"daddylonglegs" wrote:

>
> B1 is probably formatted as text
>
> this should fix it
> select B1
> Edit > Replace
> Replace = with =
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=503872
>
>

[Peo Sjoblom]

Try

="00-1-36000-21800 SPPNT HUGGIES GOODNITES"=LEFT(A2,16)


But that the text string is at least 40 characters so it can't be TRUE

--
Regards,

Peo Sjoblom

Portland, Oregon




"1stcoast" <1stcoast@discussions.microsoft.com> wrote in message
news:0B785C03-D9C3-4C61-8E20-12D9C9BBABF5@microsoft.com...
> Cell A1
> Formula in cell B1
> 00-1-36000-21800 SPPNT HUGGIES GOODNITES =LEFT(A2,16)
>
> The calculation returns the formula not a result. What am I doing wrong?

[Ron Coderre]

Try this:

First, make sure B1 is not formatted as Text.
Select B1, then Format>Cells>Number Tab
(Category should NOT be Text)

If the format is OK, then:
Select B1
Data>Text-to-Columns>Click the [Finish] button

Does that fix the problem?

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"1stcoast" wrote:

> Cell A1
> Formula in cell B1
> 00-1-36000-21800 SPPNT HUGGIES GOODNITES =LEFT(A2,16)
>
> The calculation returns the formula not a result. What am I doing wrong?

[1stcoast]

Thanks your solution fixed the problem also!

"Ron Coderre" wrote:

> Try this:
>
> First, make sure B1 is not formatted as Text.
> Select B1, then Format>Cells>Number Tab
> (Category should NOT be Text)
>
> If the format is OK, then:
> Select B1
> Data>Text-to-Columns>Click the [Finish] button
>
> Does that fix the problem?
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "1stcoast" wrote:
>
> > Cell A1
> > Formula in cell B1
> > 00-1-36000-21800 SPPNT HUGGIES GOODNITES =LEFT(A2,16)
> >
> > The calculation returns the formula not a result. What am I doing wrong?