Popup Calendar Addin for Excel

Entering dates in a worksheet confuses most Excel users. Nearly every user has faced a date format problem, which format should be used to enter date? Should we set the month first then day or other way? Which date separator to be used? Is it “/” or “-“? How will the date be parsed when … Continue reading Popup Calendar Addin for Excel

Data Validation – Use a Formula to Validate Email Addresses

Data validation is a powerful Excel feature that can be used to restrict what data can or should be entered in a cell. You can setup data validation to prevent users from entering invalid data. In this post I am sharing with you a tip on how to  setup data validation setup to restrict users from entering invalid … Continue reading Data Validation – Use a Formula to Validate Email Addresses