greekboy_uk
New Member
- Joined
- Nov 20, 2009
- Messages
- 19
Hi there,
I am trying to find a number within a cell that it is stored as text without converting the cell format to numeric.
I need a formula to check if the first character of the stored as text field is 8 and if so to give me Yes/No result. Many thanks in advance
I am trying to find a number within a cell that it is stored as text without converting the cell format to numeric.
I need a formula to check if the first character of the stored as text field is 8 and if so to give me Yes/No result. Many thanks in advance
‘81080999 | Yes |