ZIP CODE FORMATTING

[Victor Costello]

I HAVE A DATA BASE WITH THE ! ICON REFERENCE ON SOME OF MY ZIP CODE ENTRIES.
IT SAYS THAT "THE NUMBER IN THIS CELL IS FORMATTED AS TEXT OR PRECEDED BY AN
APOSTROPHE." HOW DO I FORMAT THE ZIP CODES SO THAT THEY ARE ALL THE
SAME?SOME ENTRIES DO NOT HAVE THIS DISCLAIMER.

THANKS,
VICTOR

 

[RagDyeR]

Sometimes, simply opening and closing TTC will work.
Try this:

Select the Column with the data, then:

<Data> <TextToColumns> <Finish>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I HAVE A DATA BASE WITH THE ! ICON REFERENCE ON SOME OF MY ZIP CODE ENTRIES.
IT SAYS THAT "THE NUMBER IN THIS CELL IS FORMATTED AS TEXT OR PRECEDED BY AN
APOSTROPHE." HOW DO I FORMAT THE ZIP CODES SO THAT THEY ARE ALL THE
SAME?SOME ENTRIES DO NOT HAVE THIS DISCLAIMER.

THANKS,
VICTOR

 

[Tom Ogilvy]

I believe some zipcodes can start with a zero, so they may need to be stored
as text or have a leading '

 

[RagDyeR]

Good point!

So, *perhaps* going the "other" way, and changing everything to Text , might
eliminate the annoying alert message:

<Data> <TextToColumns> <Next> <Next>
Click on "Text", then <Finish>

 

[Victor Costello]

THANKS GUYS FOR YOUR HELP. WORKED GREAT.

Good point!

So, *perhaps* going the "other" way, and changing everything to Text ,
might
eliminate the annoying alert message:

<Data> <TextToColumns> <Next> <Next>
Click on "Text", then <Finish>
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

I believe some zipcodes can start with a zero, so they may need to be
stored
as text or have a leading '

 

[Ragdyer]

Appreciate the feed-back.