View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mab2819 mab2819 is offline
external usenet poster
 
Posts: 3
Default sort by numbers of digits in cells

Hi,

I need to sort a large document by a certain column. That column consists of
numbers that are six digits and five digits. I need to insert a leading zero
in all those numbers that consist of only five digits. Some of those six
digit numbers already correctly have the leading zero, so when I sort, it
doesn't isolate the five digit ones. Any ideas on how I can do this?
TIA,
--
mab