LinkBack URL
About LinkBacks
Another way around....
Assuming that you have 100.000.01 in A1, then in B1 try this.....
=IF(AND(LEN(A1)=10,FIND(".",A1)+FIND(".",SUBSTITUTE(A1,".","^",1))=12),"Correct Format","Incorrect Format")
Another way around....
Assuming that you have 100.000.01 in A1, then in B1 try this.....
=IF(AND(LEN(A1)=10,FIND(".",A1)+FIND(".",SUBSTITUTE(A1,".","^",1))=12),"Correct Format","Incorrect Format")
Last edited by sktneer; 05-10-2014 at 05:57 AM.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
I think to check length is necessary as user may add more numbers after second "." entryOriginally Posted by sktneer
Another way around....
Assuming that you have 100.000.01 in A1, then in B1 try this.....
=IF(FIND(".",A1)+FIND(".",SUBSTITUTE(A1,".","^",1))=12,"Correct Format","Incorrect Format")
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks