5 Dec 2006 at 21:30 #1 Faithless Faithless Permabanned Joined 24 Nov 2006 Posts 560 Hi all, I have a user form which asks the user to enter a phone number including area code, which the form then places into a worksheet THing is, Excel drops the first '0' so 01344 appears as 1344 What to do?
Hi all, I have a user form which asks the user to enter a phone number including area code, which the form then places into a worksheet THing is, Excel drops the first '0' so 01344 appears as 1344 What to do?
5 Dec 2006 at 21:45 #4 Faithless Faithless Permabanned OP Joined 24 Nov 2006 Posts 560 thanks both. Daves way is slightly better Do you know of a way to always Open sheet1 regardless of what last sheet was open when Excel shut?
thanks both. Daves way is slightly better Do you know of a way to always Open sheet1 regardless of what last sheet was open when Excel shut?
