Convert Norwegian currency formatting to US/UK

**happycats** · 11-04-2011, 03:23 PM

Here is my issue:

I have an excel based output that includes numeric values that align to Norway's culture codes, which include comma formatting in place of period decimals.

I need to transfer those values from the comma formatting to the period formatting so formulas that I have that are based on period formatting can process properly.

Example, I have multiple rows of cells that contain values like 40 630,00, and I need that to appear as 40,630.00 or 40630. Make sense? attachment provided with sample of what i'm working with. see "Master Template" tab

thanks

**Paul** · 11-04-2011, 04:05 PM

Hi Happycats,

The code below will convert the values in all selected cells from "xx yyy,zz" to "xx,yyy.zz" by replacing commas with decimals and removing the non-space character where the thousands separator (comma) should be. I thought it was a standard space character at first, but I was wrong.

Please Login or Register  to view this content.

Hope it helps!

**happycats** · 11-04-2011, 04:50 PM

Hi Paul - thanks. So how can I take advantage of that? I'm no pro obviously. So is that something that coudl be put into a macro? how do I use that?

**Paul** · 11-04-2011, 05:03 PM

What I provided is a macro. Copy it, open the VB Editor in Excel (ALT+F11). Click Insert > Module. Paste the code. Close the editor.

Select any cells you want to convert on your spreadsheet, then click Developer tab > click Macros > select cNorway > click Run.