cancel
Showing results for 
Search instead for 
Did you mean: 

Excel reminder please

Community Veteran
Posts: 7,149
Thanks: 51
Fixes: 2
Registered: 30-08-2007

Excel reminder please

Its 10 -12 years or more since I used MS Excel in anger. I recall there was a small trick pre-fix that would allow whole number or some symbols such as the + sign to be typed into cells without Excel altering them to some kind of mathematical equation or, in the case of phone number STD codes dropping the first 0 when I really want to have it shown.
But I've forgotten what it is. I vaguely recalled it was a ~ (tilde) prefixed before the number or symbol but that didn't work.
Anyone help please?
Experience; is something you gain, just after you needed it most.

When faced with two choices, simply toss a coin. It works not because it settles the question for you. But because in that brief moment while the coin is in the air. You suddenly know what you are hoping for.
2 REPLIES
Community Veteran
Posts: 38,242
Thanks: 933
Fixes: 54
Registered: 15-06-2007

Re: Excel reminder please

Prefix them with ' which on my keyboard is on the @ key
Community Veteran
Posts: 7,149
Thanks: 51
Fixes: 2
Registered: 30-08-2007

Re: Excel reminder please

Thanks Jim.
Take this gold star!!
Experience; is something you gain, just after you needed it most.

When faced with two choices, simply toss a coin. It works not because it settles the question for you. But because in that brief moment while the coin is in the air. You suddenly know what you are hoping for.