Excel 2007 regional settings number formats

  Costa30 15:15 17 Sep 2010

I have to scan in a Spanish spreadsheet into Excel 2007 and create a report from the data in both Spanish and English with respective number formats, each using a seperate tab. Spanish = 0.000,00 English =0,000.00. Excel treats the imported foreign formatted numbers as text and I only seem to be able to use regional settings to change format which then applies to the whole file.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Honor 9 Lite review

How Sam Falconer transforms science and geology into digestible, elegant illustrations

HomePod review

Les meilleures séries Netflix (2018)