title: Excel - VBA : set the standard format for all the cells of my Sheet once and for all
body: <p>I am having a very annoying problem with excel : I have some VBA macros whose purpose is to fill in some other cells with some contents. My problem is that excel keeps changing the format of some cell ! Thanks but I didn't ask for this, everytime it tries to help me, it just makes things worse.<br />
  And when I right click on the cell to set the standard format and then try my macro again... it goes back to excel changes !</p>
  <p>Here is an example of the problem I am experiencing :<br />
  <img src="https://i.stack.imgur.com/R1tOF.jpg" alt="enter image description here" /></p>
  <p>Another example would be the number of decimals in a number : if my macro is copying/pasting a number with 11 decimals, excel is just gonna keep 7 !! So annoying!</p>