Cell Formula

E

Eugene

Is it any way to find out that the first cell's character
is an apostrophe? Looks like no Value neither Formula
return it.
 
N

Niek Otten

They do. But if you enter a value preceded by an apostrophe, the apostrophe
will not be entered into the cell, even if it does show in the formula bar.
You can easily test that by using the LEN() function.
If you do need the apostrophe as part of the text, you'll have to enter two
apostrophes.
 
T

Tom Ogilvy

? activeCell.prefixCharacter '<===
'
? activeCell.Value
123207
? activeCell.Text
123207
? activeCell.Formula
123207


Regards,
Tom Ogilvy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top