I'm not sure you can change this (it does it for me, too)--but why do you care?

The .numberformat of the cell is really: 0000

So it's just the way that excel displays it to you in that dialog box.

You could run a small macro to see the numberformat:

sub showNumberFormat()
msgbox activecell.numberformat
end sub

If you want to verify it.





stevieray wrote:

When I select Custom and enter 4 zeroes it changes the formating to a 'Type'
of Codigo Postal and a ' locale' of Portuguese (Portugal). How can i get this
to not happen and stay as 'Custom"?
Thanks

--

Dave Peterson