Converting from Norwegian Krone to US Dollars format
 

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)

Converting from Norwegian Krone to US Dollars format
 

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" wrote in message
...
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)

Converting from Norwegian Krone to US Dollars format
 

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

"Bernie Deitrick" wrote:

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" wrote in message
...
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)

Converting from Norwegian Krone to US Dollars format
 

Try

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

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


HTH,
Bernie
MS Excel MVP


"Jamie" wrote in message
...
This did not work. I tried more than once. Any other suggestions.

"Bernie Deitrick" wrote:

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" wrote in message
...
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)

Converting from Norwegian Krone to US Dollars format
 

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.

"Bernie Deitrick" wrote:

Try

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

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


HTH,
Bernie
MS Excel MVP


"Jamie" wrote in message
...
This did not work. I tried more than once. Any other suggestions.

"Bernie Deitrick" wrote:

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" wrote in message
...
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)

Converting from Norwegian Krone to US Dollars format
 

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.


--
Regards,

Peo Sjoblom



"Jamie" wrote in message
...
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.

"Bernie Deitrick" wrote:

Try

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

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


HTH,
Bernie
MS Excel MVP


"Jamie" wrote in message
...
This did not work. I tried more than once. Any other suggestions.

"Bernie Deitrick" wrote:

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" wrote in message
...
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)

Converting from Norwegian Krone to US Dollars format
 

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

"Peo Sjoblom" wrote:

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.


--
Regards,

Peo Sjoblom



"Jamie" wrote in message
...
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.

"Bernie Deitrick" wrote:

Try

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

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


HTH,
Bernie
MS Excel MVP


"Jamie" wrote in message
...
This did not work. I tried more than once. Any other suggestions.

"Bernie Deitrick" wrote:

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" wrote in message
...
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)

Converting from Norwegian Krone to US Dollars format
 

One way would be to change the windows settings under control panelregional
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



--
Regards,

Peo Sjoblom



"Jamie" wrote in message
...
The numbers are pulling from a web query to an international website.

"Peo Sjoblom" wrote:

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.


--
Regards,

Peo Sjoblom



"Jamie" wrote in message
...
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.

"Bernie Deitrick" wrote:

Try

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

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


HTH,
Bernie
MS Excel MVP


"Jamie" wrote in message
...
This did not work. I tried more than once. Any other suggestions.

"Bernie Deitrick" wrote:

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" wrote in message
...
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)