| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying to types of punctuation i one sheet
Hii all
I would like to display a result with EU punctuation and US punctuation in the same sheet but in different coloumns. Ex. EU: 3.438,23 US: 3,438.23 Is that possible? When i try, it converts all data in to the same punctuation I use excel 2003 european version Thanks for any help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying to types of punctuation i one sheet
Only as text: if A1 has a value of 3.438,23 as number then this formula
returns 3,438.23 as text. =SUBSTITUTE(LEFT(TEXT(A1,"#.##0,00"),LEN(TEXT(A1," #.##0,00"))-3),".",",")&"."&RIGHT(TEXT(A1,"#.##0,00"),2) Regards, Stefi €žSimon€ť ezt Ă*rta: Hii all I would like to display a result with EU punctuation and US punctuation in the same sheet but in different coloumns. Ex. EU: 3.438,23 US: 3,438.23 Is that possible? When i try, it converts all data in to the same punctuation I use excel 2003 european version Thanks for any help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying to types of punctuation i one sheet
The formula does not seem to work. But thanks anyway.
I need it as numbers. So is the only solution to have 2 different excel-books or is it possible to operate with to types of punctuation in 2 different sheets? Again thanks for any help /Simon "Stefi" wrote: Only as text: if A1 has a value of 3.438,23 as number then this formula returns 3,438.23 as text. =SUBSTITUTE(LEFT(TEXT(A1,"#.##0,00"),LEN(TEXT(A1," #.##0,00"))-3),".",",")&"."&RIGHT(TEXT(A1,"#.##0,00"),2) Regards, Stefi €žSimon€ť ezt Ă*rta: Hii all I would like to display a result with EU punctuation and US punctuation in the same sheet but in different coloumns. Ex. EU: 3.438,23 US: 3,438.23 Is that possible? When i try, it converts all data in to the same punctuation I use excel 2003 european version Thanks for any help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying to types of punctuation i one sheet
You have to use to separate workbooks and set decimal separator in
ToolsOptionsLanguage tab (I'm not sure that Language is the tab name, I'm translating it back, it's located between Color and Save). Regards, Stefi €žSimon€ť ezt Ă*rta: The formula does not seem to work. But thanks anyway. I need it as numbers. So is the only solution to have 2 different excel-books or is it possible to operate with to types of punctuation in 2 different sheets? Again thanks for any help /Simon "Stefi" wrote: Only as text: if A1 has a value of 3.438,23 as number then this formula returns 3,438.23 as text. =SUBSTITUTE(LEFT(TEXT(A1,"#.##0,00"),LEN(TEXT(A1," #.##0,00"))-3),".",",")&"."&RIGHT(TEXT(A1,"#.##0,00"),2) Regards, Stefi €žSimon€ť ezt Ă*rta: Hii all I would like to display a result with EU punctuation and US punctuation in the same sheet but in different coloumns. Ex. EU: 3.438,23 US: 3,438.23 Is that possible? When i try, it converts all data in to the same punctuation I use excel 2003 european version Thanks for any help |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying to types of punctuation i one sheet
Stefi
I think you are referring to ToolsOptionsInternational in Excel 2003. That is an Excel global setting, not a workbook setting. Gord Dibben MS Excel MVP On Mon, 5 Jan 2009 04:10:01 -0800, Stefi wrote: You have to use to separate workbooks and set decimal separator in ToolsOptionsLanguage tab (I'm not sure that Language is the tab name, I'm translating it back, it's located between Color and Save). Regards, Stefi „Simon” ezt írta: The formula does not seem to work. But thanks anyway. I need it as numbers. So is the only solution to have 2 different excel-books or is it possible to operate with to types of punctuation in 2 different sheets? Again thanks for any help /Simon "Stefi" wrote: Only as text: if A1 has a value of 3.438,23 as number then this formula returns 3,438.23 as text. =SUBSTITUTE(LEFT(TEXT(A1,"#.##0,00"),LEN(TEXT(A1," #.##0,00"))-3),".",",")&"."&RIGHT(TEXT(A1,"#.##0,00"),2) Regards, Stefi „Simon” ezt írta: Hii all I would like to display a result with EU punctuation and US punctuation in the same sheet but in different coloumns. Ex. EU: 3.438,23 US: 3,438.23 Is that possible? When i try, it converts all data in to the same punctuation I use excel 2003 european version Thanks for any help |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying to types of punctuation i one sheet
Ok...
That is to bad, means a lot of extra work for me:(. But thanks again. If anyone has a alternative solution to this problem, you´re very welcome to post it. Thanks /Simon "Gord Dibben" wrote: Stefi I think you are referring to ToolsOptionsInternational in Excel 2003. That is an Excel global setting, not a workbook setting. Gord Dibben MS Excel MVP On Mon, 5 Jan 2009 04:10:01 -0800, Stefi wrote: You have to use to separate workbooks and set decimal separator in ToolsOptionsLanguage tab (I'm not sure that Language is the tab name, I'm translating it back, it's located between Color and Save). Regards, Stefi €žSimon€ť ezt Ă*rta: The formula does not seem to work. But thanks anyway. I need it as numbers. So is the only solution to have 2 different excel-books or is it possible to operate with to types of punctuation in 2 different sheets? Again thanks for any help /Simon "Stefi" wrote: Only as text: if A1 has a value of 3.438,23 as number then this formula returns 3,438.23 as text. =SUBSTITUTE(LEFT(TEXT(A1,"#.##0,00"),LEN(TEXT(A1," #.##0,00"))-3),".",",")&"."&RIGHT(TEXT(A1,"#.##0,00"),2) Regards, Stefi €žSimon€ť ezt Ă*rta: Hii all I would like to display a result with EU punctuation and US punctuation in the same sheet but in different coloumns. Ex. EU: 3.438,23 US: 3,438.23 Is that possible? When i try, it converts all data in to the same punctuation I use excel 2003 european version Thanks for any help |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying to types of punctuation i one sheet
Sorry, I didn't check it. I thought that unchecking system settings makes a
single workbook independent of systems setings and not the whole Excel application. Thank you for correcting my fault. Stefi €žGord Dibben€ť ezt Ă*rta: Stefi I think you are referring to ToolsOptionsInternational in Excel 2003. That is an Excel global setting, not a workbook setting. Gord Dibben MS Excel MVP On Mon, 5 Jan 2009 04:10:01 -0800, Stefi wrote: You have to use to separate workbooks and set decimal separator in ToolsOptionsLanguage tab (I'm not sure that Language is the tab name, I'm translating it back, it's located between Color and Save). Regards, Stefi €žSimon€ť ezt Ă*rta: The formula does not seem to work. But thanks anyway. I need it as numbers. So is the only solution to have 2 different excel-books or is it possible to operate with to types of punctuation in 2 different sheets? Again thanks for any help /Simon "Stefi" wrote: Only as text: if A1 has a value of 3.438,23 as number then this formula returns 3,438.23 as text. =SUBSTITUTE(LEFT(TEXT(A1,"#.##0,00"),LEN(TEXT(A1," #.##0,00"))-3),".",",")&"."&RIGHT(TEXT(A1,"#.##0,00"),2) Regards, Stefi €žSimon€ť ezt Ă*rta: Hii all I would like to display a result with EU punctuation and US punctuation in the same sheet but in different coloumns. Ex. EU: 3.438,23 US: 3,438.23 Is that possible? When i try, it converts all data in to the same punctuation I use excel 2003 european version Thanks for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| remove punctuation from address | New Users to Excel | |||
| Remove Punctuation? | Excel Worksheet Functions | |||
| How to I change punctuation spacing | Excel Discussion (Misc queries) | |||
| the box where one types on the top of the excel sheet is missing. | Excel Discussion (Misc queries) | |||
Linear Mode
