Thread: How do I convert a number in Excel such as 1001-1 to 1001-01?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default How do I convert a number in Excel such as 1001-1 to 1001-01?
Here's another formula to try out...

=IF(MID(A1,LEN(A1)-1,1)="-",SUBSTITUTE(A1,"-","-0"),A1)

--
Rick (MVP - Excel)


"Bob" wrote in message
...
I have several hundred numbers in my Excel file that need to be converted
as
noted in the subject. The sorting is awkward in that 1001-11 sorts before
1001-2 and is obviously out of order- at least for my purposes.
--
SgtBob

Reply With QuoteReply With Quote