Thread: Adding a dash
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Adding a dash

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