Posted to microsoft.public.excel.worksheet.functions

sergio789

external usenet poster

Posts: 1

Can you change normal numbers to ordinal numbers ?

For example if you typed 7 in one cell but in another cell where cell one =
the 2nd cell you want it to appear as 7th not 7 ???

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel, change column of negative numbers to positive numbers?	Nita	New Users to Excel	3	November 27th 07 04:54 AM
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
change 2000 cells (negative numbers) into positive numbers	lisbern	Excel Worksheet Functions	2	August 16th 06 05:54 PM

All times are GMT +1. The time now is 11:50 PM.

About Us

"It's about Microsoft Excel"