Converting from Norwegian Krone to US Dollars format

[Jamie]

I have a spreadsheet with Data in the currency format of Norwegain Krones
(NOK) (they use commas where we use periods and periods where we use commas)
and I need to be able to convert the format of the data into the US Dollar
format.
Current Data: 143,00
In USD format: 143.00
All I need is to be able to change the format so I can multiply the Krones
by the conversion rate for US Dollars.
(NOK is not included in Euro conversion)

 

[Bernie Deitrick]

Jamie,

Try Tools / Options... International tab, check "Use system separators" and the format should
change to your default style.

HTH,
Bernie
MS Excel MVP

 

[Jamie]

This did not work. I tried more than once. Any other suggestions.

 

[Bernie Deitrick]

Try

1) Edit Find/Replace.. Replace , with .

2) =VALUE(SUBSTITUTE(A1,",","."))


HTH,
Bernie
MS Excel MVP

 

[Jamie]

Thanks. #2 worked. I thought about using Find and Replace but I'm trying to
get this spreadsheet to update everything on it's own.

 

[Peo Sjoblom]

If it is indeed a spreadsheet with numbers and not text it should convert
without any problems just the same way dates or other regional settings do.
Meaning that if you get it from someone in Norway it should work, of course
if it is done on a US computer it will be seen as text.

 

[Jamie]

The numbers are pulling from a web query to an international website.

 

[Peo Sjoblom]

One way would be to change the windows settings under control panel>regional
settings to
Norwegian format, do the import and switch back and it should convert or if
you want to automate it just record a macro when you replace them, save the
macro in your personal.xls and attach it to the toolbar or use a keyboard
shortcut