Hi guys,
I'm trying to create a validation rule that ensures that phone numbers entered under a field appear in the following format style:
0# #### ####
I can achieve this through the Custom option in Format Cells (the 0 at the front is there because Excel removes it because it thinks it's redundant) but I'm not sure how I can limit the users to only use the above format - I was thinking it might be to do with validation. Any advice?
Cheers,
Sten
I'm trying to create a validation rule that ensures that phone numbers entered under a field appear in the following format style:
0# #### ####
I can achieve this through the Custom option in Format Cells (the 0 at the front is there because Excel removes it because it thinks it's redundant) but I'm not sure how I can limit the users to only use the above format - I was thinking it might be to do with validation. Any advice?
Cheers,
Sten