Thread: Adding a dash
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Adding a dash

Jim,

Select those cells and then

Format|Cells - Custom

enter a custom format of

0-00

Mike

"Jim" wrote:

Hello,

I have a column of numbers that I pulled from a database. The numbers look
like this:

159611
2395301
12451111
69996709

I need to add a dash in order to seperate teh last two digits. What is hte
best way to perform this task?

The numbers should look like this:
1596-11
23953-01
124511-11
699967-09

Thanks