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


"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)

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)

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)

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)

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)