ExcelBanter - automatic formatting of cells to currency in Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - automatic formatting of cells to currency in Excel 2007 (https://www.excelbanter.com/excel-worksheet-functions/121092-automatic-formatting-cells-currency-excel-2007-a.html)

mikky

automatic formatting of cells to currency in Excel 2007

I open an Excel XP file under Excel 2007 and covert it into Excel 2007 file
format. However numeric values with decimal comma get formatted as currency
(with the euro sign in front of them). How do I stop that annoying formatting?

All times are GMT +1. The time now is 05:40 AM.