title: How to convert numbers from European format to British in excel (separator commas to dots)?
body: <p>I have excel files containing data in European format. Thousand separator is a dot, but I want to use a comma. I can easily convert it using =SUBSTITUTE function. However, when I do that I lose zeros at the end of the number.
  For instance
  11.500  (converts to) 11,5 (eleven thousand five hundred becomes eleven and a half)</p>
  
  <p>After the conversion, I tried to change the custom format, but I had no luck.</p>
  
  <p>Any ideas?</p>