View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mary Mary is offline
external usenet poster
 
Posts: 190
Default Format from 870914143 to 8-709-14143

THANK YOU SO MUCH ALL

"Toppers" wrote:

Format cell as:

Custom==0-000-00000

HTH

"Mary" wrote:

Hi,
I have a column that I would like to format like the sample below. I want to
keep the dashes between the numbers.
from 870914143 to 8-709-14143
Thank you so much