Feb 23, 2010 #1 foxbox Programmer Sep 11, 2000 1,052 NL i give an Excel cell a custom format 0000. After clicking OK, i do again "Format cell..." Now it is set to "Special" Codigo Portugal! Oke, the effect is the same, but it looks strange. Is it possible to edit the special formats? or better: disable them?
i give an Excel cell a custom format 0000. After clicking OK, i do again "Format cell..." Now it is set to "Special" Codigo Portugal! Oke, the effect is the same, but it looks strange. Is it possible to edit the special formats? or better: disable them?
Feb 23, 2010 #2 S SkipVought Programmer Dec 4, 2001 47,492 US Make your own, in Custom. Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
Feb 23, 2010 Thread starter #3 foxbox Programmer Sep 11, 2000 1,052 NL i give an Excel cell a custom format 0000." so now there is a "0000" under special and a "0000" under custom Upvote 0 Downvote
i give an Excel cell a custom format 0000." so now there is a "0000" under special and a "0000" under custom
Feb 23, 2010 #4 S SkipVought Programmer Dec 4, 2001 47,492 US Is this causing a problem? 0000 happens to be the format for Portuguese (Portugal) Postal Codes. SO WHAT! Is this causing a problem? I havn't lost any sleep over it. Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
Is this causing a problem? 0000 happens to be the format for Portuguese (Portugal) Postal Codes. SO WHAT! Is this causing a problem? I havn't lost any sleep over it. Skip, Just traded in my old subtlety... for a NUANCE!