Paulasirius
New Member
- Joined
- Feb 23, 2002
- Messages
- 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
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