View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
richdsn2 richdsn2 is offline
external usenet poster
 
Posts: 2
Default Entering a mac address in a cell

I want to enter a series of 50 mac addresses into an Excel spreadsheet. How
do I format the cell so that all I have to do is enter the hexidecimal
numbers, and Excel will automatically enter a colon between each set of two
numbers?