Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert german format numbers to british format
-- Boysie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert german format numbers to british format
How do German and British formats differ?
"boysie" wrote: -- Boysie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert german format numbers to british format
What is the difference between German and British formatting of numbers?
The comma and dot functions are reversed? Change your Regional and Language Options in Windows. Gord Dibben MS Excel MVP On Sat, 8 Mar 2008 02:15:01 -0800, boysie wrote: |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert german format numbers to british format
The comma and dot functions are reversed?
You can also use this function to make a number of the text number With the text number in A2 you can use this =IF(ISERR(A2*1),IF(ISERR("1.2"*1),SUBSTITUTE(SUBST ITUTE(A2,",",""),".",",")*1,SUBSTITUTE(SUBSTITUTE( A2,".",""),",",".")*1),A2*1) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gord Dibben" <gorddibbATshawDOTca wrote in message ... What is the difference between German and British formatting of numbers? The comma and dot functions are reversed? Change your Regional and Language Options in Windows. Gord Dibben MS Excel MVP On Sat, 8 Mar 2008 02:15:01 -0800, boysie wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert numbers to text format? | Excel Discussion (Misc queries) | |||
how to convert numbers to number name format ,1 to one | Excel Discussion (Misc queries) | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
How to convert decimal numbers to time format | Excel Worksheet Functions | |||
Can i convert numbers into string format? | Excel Discussion (Misc queries) |