Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Odd Question
Is any set of characters containing a letter, hypen or space considered a
text or a title? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
If Question | Excel Worksheet Functions | |||
IF Question | Excel Worksheet Functions |