Thread: Reducing the number of digits in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Borge14 Borge14 is offline
external usenet poster
  
Posts: 1
Default Reducing the number of digits in a cell

Hi,

Is there a way of automatically reducing the number of digits in a
cell?

I have a spreadsheet containing 16,000 zip/postcodes. I need to remove
the last two digits in each postcode. Is this possible?

Any help that anyone can give would be much appreciated.

Thanks,
George


--
Borge14
------------------------------------------------------------------------
Borge14's Profile: http://www.excelforum.com/member.php...o&userid=37324
View this thread: http://www.excelforum.com/showthread...hreadid=570270

Reply With QuoteReply With Quote