Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
HELP WITH POSTCODE FORMATTING
0 views
Skip to first unread message
EXCEL MAN@discussions.microsoft.com UK EXCEL MAN
Dec 27, 2004, 3:29:03 AM12/27/04
to
4 possible uk postcode formats (AANN NAA, ANN NAA, AAN NAA, AN NAA)
A="ALPHA", N="NUMBER"
A="ALPHA", N="NUMBER"
Does anyone know of a custom format/formula so that I can format data to suit?
Frank Kabel
Dec 27, 2004, 4:01:02 AM12/27/04
to
Hi
not possible with a format as you have characters in your data
not possible with a format as you have characters in your data
0 new messages