ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Ordinal Nummbers List (https://www.excelbanter.com/excel-programming/315340-ordinal-nummbers-list.html)

geotso[_2_]

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



keepITcool

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?



geotso[_2_]

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?




keepITcool

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?







All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com