Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I format numbers to ordinal i.e. 1st, 2nd etc chieflx Excel Worksheet Functions 9 February 21st 09 11:59 AM
duplicate occurance, assigning an ordinal value mcheng Excel Worksheet Functions 14 June 14th 07 05:21 PM
Ordinal Numbers Epinn Excel Worksheet Functions 12 October 27th 06 08:43 AM
Format cells to display ordinal numbers ex 21st Prince of Tama Excel Worksheet Functions 1 October 17th 06 08:09 AM
display dates with ordinal numbers in excel Tim Green Excel Discussion (Misc queries) 6 September 7th 06 04:37 PM


All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"