stephjayne165
New Member
- Joined
- Jan 20, 2012
- Messages
- 23
Hey Guys,
After hours of googling and not being able to find anything that works for me, I need your help!!
I have come to the conclusion that what I want to do is not possible by formula, and therefore I'm looking at VBA. However, my VBA knowledge is severly limited at best, so I'm going to explain what I want, and hope that on eof you understands and is able to provide me some much needed assistance!
I need to calculate the below for each row in a column of data
IF the field contains only numbers THEN, IF the field is prefixed with an apostrophe, RETURN true/false.
So essentially, if the field is numbers only, is the number prefixed with an apostrophe? yes or no.
The first section I can do with an IF statement and ISNUMBER formula. It's the second part I'm having difficulties with.
Any questions, please let me know.
And, as always, thank you for your assistance, it is very much appreciated!!
Cheers,
Steph
After hours of googling and not being able to find anything that works for me, I need your help!!
I have come to the conclusion that what I want to do is not possible by formula, and therefore I'm looking at VBA. However, my VBA knowledge is severly limited at best, so I'm going to explain what I want, and hope that on eof you understands and is able to provide me some much needed assistance!
I need to calculate the below for each row in a column of data
IF the field contains only numbers THEN, IF the field is prefixed with an apostrophe, RETURN true/false.
So essentially, if the field is numbers only, is the number prefixed with an apostrophe? yes or no.
The first section I can do with an IF statement and ISNUMBER formula. It's the second part I'm having difficulties with.
Any questions, please let me know.
And, as always, thank you for your assistance, it is very much appreciated!!
Cheers,
Steph
