Thread: Format a number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jlo jlo is offline
external usenet poster
 
Posts: 16
Default Format a number

Is there a way to format a number 00000000000 to '00000-000000',

I need the quotes, dash and comma.

I found a style to work but I have to click on each cell to see it change.