Thank you very much from the deepest of my hart!
Mr. Peter and Mr. Rothstein your formula feed-back works great; Thank again


"Help on formula" wrote:

Hi

In Column-A there is a list of numbers with hyphen i.e.:
95818-125199

How can this list of numbers covert into following format in Column-B?
95818-1251-99

In other words of explanation is that I want to keep this format
95818-125199 in Column-A, but to change the format into 95818-1251-99 in
Column-B. Please help me with Formula or Macro so each time when I enter
95818-125199 in Column-A it can convert automatically in the format of
95818-1251-99 in Column-B. I thank you in advance.