title: Number to be copied from cell with the same number format and show it as a label for a shape without any change in the number format
body: <p>I have a cell in excel which contains a value, lets say 100000.
  Now i want this value to have commas in between them to represent the thousands and millions i.e. 100,000. I can do this by changing the number format in the home menu.
  Now i want this value to be copied from that cell and paste it as a label for a shape. When i am doing this the commas go away showing me just the numbers. 
  I want it to happen through VBA but this is not happening in excel itself.</p>
  
  <p>Does anyone have a plausible solution for this?</p>