hello,
I have just started learning macros recently. i have a requirement that says Check if column entries contains numbers 0-9 and can have just one decimal. my Problem here is i have an entry on cell that is 6% and another cell with value 0.06
in this case,expectation is cell entry 6% must fail as it has a percentage symbol but pass the other entry with 0.06, now how do i achieve this? because vba functions reads 6% as 0.06 and passes the scenario instead of failing.
Thanks in advance!
Bookmarks