Excel Number Question

  • Thread starter Thread starter Carl Mankat
  • Start date Start date
C

Carl Mankat

I should know this one but I'm rusty.

I'm using Excel 97. I received a spreadsheet with a filed of Zip Codes
that has two different appearances. Most of the numbers are '85226 and
are left aligned. A few of them are 85226 (no ' ) and are right aligned.
Is there an easy way to edit the Zip Codes to remove the ' and have them
all line up the same way?

TIA,

Carl
 
Hi Carl,

With any empty cell selected, try:

Edit | Copy | Select zip code cells | Edit | Paste Special | Add | Ok
 
Hi Carl,
Is this available via HELP?
Click to expand...

AFAIK, no.

However, the addition of 0 (zero) or the multiplication by 1 or -1, are
techniques widely used to coerce text or booleans to a numeric values. Such
coercion is also often effected by the use of a double unary minus (--).
 
Back
Top