All posts in category Microsoft Excel

Ordinal Suffixes for all dates and numbers; Show 3rd instead of 3

A surprising omission from the extensive number formatting goodies in Visual Basic (VB) is the ability to append the appropriate ordinal suffix to a number. This is most often used when writing dates in prose. For example, you would write 3rd February 2009, not 3 February 2009. This VB / VBA function returns your number [...]

2 Comments
by Mister Slimm on February 13, 2009  •  Permalink
Posted in Microsoft Access, Microsoft Excel, VB VBA Visual Basic for Applications

Posted by Mister Slimm on February 13, 2009

http://misterslimm.wordpress.com/2009/02/13/ordinal-suffixes-for-all-dates-and-numbers-show-3rd-instead-of-3/

Follow

Get every new post delivered to your Inbox.