how to make excel write exaclty what i want and do not change it?

[john65442]

Hi:-

I have written

-h
into excel document
and excel changed it to

#NAME?

and i also wrote
-W8
and excel changed it to
0

How can i stop this ?
when i write -h i want it to appear -h and not #NAME?

 

[Claymationator]

Welcome to the board!

Just type in an apostrophe before the text you want to show. Right now when you type in the "-" it is assuming that it is a formula...hence the error and 0 values you are getting. Instead type this:

'-h
'-W8

The apostrophe will tell Excel that you want it to be text.

Hope that helps.