View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Help on formula[_2_] Help on formula[_2_] is offline
external usenet poster
 
Posts: 10
Default Help on conversion

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.