Number formats

Paulasirius · Apr 19th, 2002, 05:37 AM

Would anyone have any ideas on how to format numbers in the form of 1st, 2nd, 3rd, 4th, etc.?
These are conditional formats in which the two letters following the number are dependant on the units value of the number, as in common use of dates such as 22nd April.
I would imagine that such formatting must be commonplace in the commercial workplace, but I can't think of how to get there. Any practical and simple solutions would be greatly appreciated

_________________
Paula in Eastbourne UK

[ This Message was edited by: Paulasirius on 2002-04-19 04:39 ]

JIMMARSHALL6660 · Apr 19th, 2002, 05:46 AM

Hi Paula,

What exactly is it that you are trying to do as there is a limit of 3 conditions in conditional formatting.

Email me a copy of the file etc .

Jim

lenze · Apr 19th, 2002, 07:35 AM

See Chip Pearson's site regarding ordinal numbers in Excel.

http://www.cpearson.com/excel/ordinal.htm

Paulasirius · Apr 19th, 2002, 10:36 AM

Thank you, Ienze, Chip Pearson's two solutions are simply brilliant and very practical.
I am going to try using VBA for the first time. I don't know how it is used but I'll figure it out. I used to be a wizard with Basic, Cobol and similar languages in the 80's but I've never got round to using VBA yet. It's not the code writing so much as the what to do with it once you've written the damn thing. I definitely seem to be missing out on a lot without VBA.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 05:37 AM	#1
Paulasirius New Member Join Date: Feb 2002 Location: Eastbourne Posts: 8	Would anyone have any ideas on how to format numbers in the form of 1st, 2nd, 3rd, 4th, etc.? These are conditional formats in which the two letters following the number are dependant on the units value of the number, as in common use of dates such as 22nd April. I would imagine that such formatting must be commonplace in the commercial workplace, but I can't think of how to get there. Any practical and simple solutions would be greatly appreciated _________________ Paula in Eastbourne UK [ This Message was edited by: Paulasirius on 2002-04-19 04:39 ]

Apr 19th, 2002, 05:46 AM	#2
JIMMARSHALL6660 New Member Join Date: Mar 2002 Location: Glasgow Posts: 12	Hi Paula, What exactly is it that you are trying to do as there is a limit of 3 conditions in conditional formatting. Email me a copy of the file etc . Jim

Apr 19th, 2002, 07:35 AM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	See Chip Pearson's site regarding ordinal numbers in Excel. http://www.cpearson.com/excel/ordinal.htm

Apr 19th, 2002, 10:36 AM	#4
Paulasirius New Member Join Date: Feb 2002 Location: Eastbourne Posts: 8	Thank you, Ienze, Chip Pearson's two solutions are simply brilliant and very practical. I am going to try using VBA for the first time. I don't know how it is used but I'll figure it out. I used to be a wizard with Basic, Cobol and similar languages in the 80's but I've never got round to using VBA yet. It's not the code writing so much as the what to do with it once you've written the damn thing. I definitely seem to be missing out on a lot without VBA.