Odd Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is any set of characters containing a letter, hypen or space considered a
text or a title?

Thanks
 
Excel would consider this to be text (or a "string"), but not
necessarily a title.

However, you may see something like "2.1 p/min" in a cell (without the
quotes) and this is not necessarily text - the cell could be formatted
to add " p/min" after the number in there (in this case 2.1), so the
cell would actually contain a numeric value.

Similarly, you might see 63.9 in a cell, and this may be text rather
than a number - it might have been entered as '63.9, but the
apostrophe won't normally show.

Hope this helps.

Pete
 
Thank you - that helps!

Pete_UK said:
Excel would consider this to be text (or a "string"), but not
necessarily a title.

However, you may see something like "2.1 p/min" in a cell (without the
quotes) and this is not necessarily text - the cell could be formatted
to add " p/min" after the number in there (in this case 2.1), so the
cell would actually contain a numeric value.

Similarly, you might see 63.9 in a cell, and this may be text rather
than a number - it might have been entered as '63.9, but the
apostrophe won't normally show.

Hope this helps.

Pete
Click to expand...
 
Back
Top