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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?