| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Norwegian stocks into Excel | Excel Discussion (Misc queries) | |||
| Converting currency from US Dollar into Canadian dollars from column A to Column B | Excel Worksheet Functions | |||
| converting time worked to dollars earned. | New Users to Excel | |||
| converting #dollars into word dollars? | Excel Worksheet Functions | |||
Linear Mode
