Hi,


You would need a macro to do it in the same column but you can format your
numbers to a different column like this and hide the original column.
Alternatively you can copy this column and paste it back over the originial
using paste special - values.

=LEFT(A1,LEN(A1)-2)&"-"&RIGHT((A1),2)

Mike

"Jim" wrote:

Hello,

In would like help with adding a dash to a series of numbers. I know I can
format with special formatting using 0-00. However the result does return a
hit when I search with the -00. Can you offer a formula that will add the
dash and yield a result that can be searched.

Thanks for the help (example below)

Now Needs to be
38605.................386-05
118306...............1183-06
511602...............5116-02
553404...............5534-04
553703...............5537-03
597309...............5973-09
597704...............5977-04