Excel Help again - sorry. Precedding Zero's

Faithless · 5 Dec 2006 at 21:30

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?

Ace Modder · 5 Dec 2006 at 21:34

tell him tor ight click the cell, click format cells...and set the data type to "text"

DaveMac · 5 Dec 2006 at 21:40

Format cells > custom > enter five zeros.

Faithless · 5 Dec 2006 at 21:45

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?

DaveMac · 5 Dec 2006 at 22:16

Faithless said:
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?

NP, not sure on the saving though as I've never needed to do that :confused:

Demo · 7 Dec 2006 at 15:29

Faithless said:
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?

I don't think there is an option to specify a default worksheet for a workbook.

One way of doing this is to create an auto_open macro. Open up the VBA editor, insert a module and dump the following code into it.

Sub auto_open()

Sheet1.Select

End Sub

If you aren't confident with the VBA editor you could just record a macro of you switching to sheet1 (you need to be on a different sheet when you start recording). The important part is for it to be called auto_open as Excel runs this macro on opening the spreadsheet that contains it.