Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ordinal Nummbers List
Hi,
English Excel XP I've got expands an ordinal numbers list when it is in English. How can I make it expand an ordinal numbers list in Greek which is like 1os, 2os, 3os...nos? -- Merlin dying to the Lady of the Lake: "We lived our lives with passion and devotion" -- Please, remove the TRAP to contact me -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ordinal Nummbers List
It will not work completely the same... (MS is still somewhat USenglish focused.. :( But.. as an intermediate solution. create the list manually.. then import in as a custom list in Tools/Options/Custom Lists keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "geotso" wrote : Hi, English Excel XP I've got expands an ordinal numbers list when it is in English. How can I make it expand an ordinal numbers list in Greek which is like 1os, 2os, 3os...nos? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ordinal Nummbers List
Yes... I've tried already with custom Lists, but how much millions of
numbers can I add?... (I'm joking) I thought that could be something more "mathematic". Something like (If I may express it by words): If the cell contains a number followed by "os" (like "1os" which means 1st in my language) then fill the next cell with [Cell's number]+1 and keep "os" too. What about that (if it makes any sense)? keepITcool wrote: It will not work completely the same... (MS is still somewhat USenglish focused.. :( But.. as an intermediate solution. create the list manually.. then import in as a custom list in Tools/Options/Custom Lists keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "geotso" wrote : Hi, English Excel XP I've got expands an ordinal numbers list when it is in English. How can I make it expand an ordinal numbers list in Greek which is like 1os, 2os, 3os...nos? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ordinal Nummbers List
if tina onassis (or what's her name) buys Microsoft.. then maybe :)
else if you use a custom number format but leave the value in the cell numeric then it will work (if 1st,2nd,3rd is all 1os,2os in Greek! keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "geotso" wrote : Yes... I've tried already with custom Lists, but how much millions of numbers can I add?... (I'm joking) I thought that could be something more "mathematic". Something like (If I may express it by words): If the cell contains a number followed by "os" (like "1os" which means 1st in my language) then fill the next cell with [Cell's number]+1 and keep "os" too. What about that (if it makes any sense)? keepITcool wrote: It will not work completely the same... (MS is still somewhat USenglish focused.. :( But.. as an intermediate solution. create the list manually.. then import in as a custom list in Tools/Options/Custom Lists keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "geotso" wrote : Hi, English Excel XP I've got expands an ordinal numbers list when it is in English. How can I make it expand an ordinal numbers list in Greek which is like 1os, 2os, 3os...nos? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I format numbers to ordinal i.e. 1st, 2nd etc | Excel Worksheet Functions | |||
duplicate occurance, assigning an ordinal value | Excel Worksheet Functions | |||
Ordinal Numbers | Excel Worksheet Functions | |||
Format cells to display ordinal numbers ex 21st | Excel Worksheet Functions | |||
display dates with ordinal numbers in excel | Excel Discussion (Misc queries) |