ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Odd Question (https://www.excelbanter.com/excel-discussion-misc-queries/149829-odd-question.html)

roxanne

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

Thanks

Pete_UK

Odd Question
 
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

On Jul 11, 6:48 pm, Roxanne wrote:
Is any set of characters containing a letter, hypen or space considered a
text or a title?

Thanks




CLR

Odd Question
 
Nice answer Pete.........

Vaya con Dios,
Chuck, CABGx3



"Pete_UK" wrote:

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

On Jul 11, 6:48 pm, Roxanne wrote:
Is any set of characters containing a letter, hypen or space considered a
text or a title?

Thanks





roxanne

Odd Question
 
Thank you - that helps!

"Pete_UK" wrote:

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

On Jul 11, 6:48 pm, Roxanne wrote:
Is any set of characters containing a letter, hypen or space considered a
text or a title?

Thanks





Pete_UK

Odd Question
 
Thanks for the feedback - both of you!

Pete

On Jul 11, 9:34 pm, Roxanne wrote:
Thank you - that helps!



"Pete_UK" wrote:
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


On Jul 11, 6:48 pm, Roxanne wrote:
Is any set of characters containing a letter, hypen or space considered a
text or a title?


Thanks- Hide quoted text -


- Show quoted text -





All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com