So, I posted a couple days ago about a really annoying bug where Excel 2008 documents with celles formatted using the € currency get “converted” to $ when you close and reopen them.

Well, I sort of found a cure. A workaround really… Well, two actually.

1) Simply save your document using the .xsl format instead of the default new .xlsx format and the problem goes away. Or,

2) instead of using the Format Cell menu option then choosing Currency and €, simply use the € icon in the formatting toolbar, or use the Financial cell format (that’s what the € icon does). It does almost the same as the € “currency” format, simply adding a space between the number and the symbol…

Don’t you love M$ products?

This entry was posted on Friday, May 16th, 2008 at 08:21 CEST and is filed under Rants & Raves, Software, tips. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.