View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FRISBIE RGW FRISBIE RGW is offline
external usenet poster
 
Posts: 1
Default excell number formatting

I am trying to take 3 cells and merge the information into one cell while
changing the formatting.

enter 23, 45, 670 into 3 cells. Have a return of 023-045-670 in one cell.
I need to use this # as if it were 23045670 and be able to sort and add to
it. I know how to mege the cell it's the return of 023 from 23 that seems
most problematic.