Formating
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 |
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 |
All times are GMT +1. The time now is 08:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com