Converting from Norwegian Krone to US Dollars format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Jamie,

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

HTH,
Bernie
MS Excel MVP
 
Try

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

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


HTH,
Bernie
MS Excel MVP
 
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.
 
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.
 
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
 
Back
Top