enter string that start with a "="
 

Does anyone know how to enter a string that starts with an equal sign. I
want to use a function that gets created from a number of strings but I can't
insert this string into a cell. It creates a runtime 1004 error.

enter string that start with a "="
 

cluckers" wrote:
Does anyone know how to enter a string that starts
with an equal sign.

Format the cell as Text first, or type an apostrophe (single quote) before
the equal sign. The apostrophe will not be considered part of the text.


----- original message -----

"cluckers" wrote:
Does anyone know how to enter a string that starts with an equal sign. I
want to use a function that gets created from a number of strings but I can't
insert this string into a cell. It creates a runtime 1004 error.

enter string that start with a "="
 

Precede it with an apostrophe.

HTH
Regards,
Howard

"cluckers" wrote in message
...
Does anyone know how to enter a string that starts with an equal sign. I
want to use a function that gets created from a number of strings but I
can't
insert this string into a cell. It creates a runtime 1004 error.

enter string that start with a "="
 

Precede it with an apostrophe.
--
David Biddulph

cluckers wrote:
Does anyone know how to enter a string that starts with an equal
sign. I want to use a function that gets created from a number of
strings but I can't insert this string into a cell. It creates a
runtime 1004 error.

enter string that start with a "="
 

Check your other thread--it's not a problem with the equal sign, it's a problem
with your formula.

cluckers wrote:

Does anyone know how to enter a string that starts with an equal sign. I
want to use a function that gets created from a number of strings but I can't
insert this string into a cell. It creates a runtime 1004 error.

--

Dave Peterson

enter string that start with a "="
 

I am tryin to input a function. these start with =. If I put an ' before it
it does not work as a function. If I input the function as string in vba it
will have a runtime error 1004.

"David Biddulph" wrote:

Precede it with an apostrophe.
--
David Biddulph

cluckers wrote:
Does anyone know how to enter a string that starts with an equal
sign. I want to use a function that gets created from a number of
strings but I can't insert this string into a cell. It creates a
runtime 1004 error.


.

enter string that start with a "="
 

You said you wanted a *string*.
If you want a function, you start with the = sign, without the apostrophe.
--
David Biddulph

"cluckers" wrote in message
...
I am tryin to input a function. these start with =. If I put an ' before
it
it does not work as a function. If I input the function as string in vba
it
will have a runtime error 1004.

"David Biddulph" wrote:

Precede it with an apostrophe.
--
David Biddulph

cluckers wrote:
Does anyone know how to enter a string that starts with an equal
sign. I want to use a function that gets created from a number of
strings but I can't insert this string into a cell. It creates a
runtime 1004 error.


.