Excel 2007 regional settings number formats

  Costa30 15:15 17 Sep 10
Locked

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.

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

1995-2015: How technology has changed the world in 20 years

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's most powerful…

Apple Watch 2 vs Huawei Watch 2 comparison review: watch out for 4G smartwatches Apple