 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Ordinals
Hello, I would like excel to automaticly generate ordinals for me, actualy autofill.. in format: 1. 2. 3. 4. 5. etc. but with the dots, it will autofill if there are no dots but I need excel to autofill ordinals with dots like I wrote... Can someone help please? Thanks Try using a custom number format Select the first number From the Excel Main Menu: <format><cells><number tab> Category: Custom Type: 0. Click [OK] Now try using the autofill. 1. would extend down like this 2. 3. etc Note: the dots wouldn't actuall exist in the cell values....but they WILL display. Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > Hello, > [quoted text clipped - 15 lines] > > Thanks Not working. Still just copying like: 1. 2. 3. 1. 2. 3. etc. any other solutions? Thanks > Try using a custom number format > [quoted text clipped - 45 lines] >> >> Thanks Hi Borat Did you select the column before doing Ron's instructions. It should work. Regards Cimjet > Not working. > [quoted text clipped - 61 lines] >>> >>> Thanks Yes I did select column. If i put dot after number it just copy series for me like: 1. 2. 3. 1. 2. 3. and if I dont put dot, it continues series like it should 1 2 3 4 5 6 so <format><cells><number tab> Category: Custom Type: 0. Click [OK] didnt help me, i hope I did it right... can you make one excel file that do what I asked so maybe i realize where I did wrong... Thanks > Hi Borat > Did you select the column before doing Ron's instructions. [quoted text clipped - 66 lines] >>>> >>>> Thanks Just checking.... In this line of the number formatting: Type: 0. That's 0 followed by a period. (you need to enter the period) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > Yes I did select column. If i put dot after number it just copy series for > me like: [quoted text clipped - 96 lines] >>>>> >>>>> Thanks If I put 1 . 2 . 3 . it will work like that... but that is not what I need, I need dot to be after numbers without space between.. Did I understand your question? Thanks > Just checking.... > [quoted text clipped - 113 lines] >>>>>> >>>>>> Thanks Hi Borat It looks like the formating is working. Type 1 and next cell below it type 2 then select both cells with the bottom right corner and drag down. Post back if it still not working. Regards Cimjet > Yes I did select column. If i put dot after number it just copy series for > me like: [quoted text clipped - 96 lines] >>>>> >>>>> Thanks No, if I put 1. 2. that it gives me 1. 2. 1. 2. 1. 2. 1. ... but if I put 1 2 it works, but I need that dot after numeber because that is how we write ordinal numbers. so I need 1. 2. 3. 4. 5. 6. 7. etc. > Hi Borat > It looks like the formating is working. [quoted text clipped - 103 lines] >>>>>> >>>>>> Thanks Hi Again Are you holding down the Ctrl key in the same time you are dragging down. Cimjet > No, if I put > [quoted text clipped - 136 lines] >>>>>>> >>>>>>> Thanks Yes, I tried and it makes no change... thanks for your effort.. maybe we will figure it out. I hope so.. > Hi Again > Are you holding down the Ctrl key in the same time you are dragging down. [quoted text clipped - 139 lines] >>>>>>>> >>>>>>>> Thanks > Yes, I tried and it makes no change... > > thanks for your effort.. maybe we will figure it out. I hope so.. Borat, if its just a formatting problem, - then drag your numbers by themselves (you already have that part easy enough) - highlight the column - right click on the highlighted part - click format cells - click custom - in the Type box use just type 0. - the sample should show you what you want to see - click ok the column should all have numbers with . behind them hope that works for you. Have you suceed to do it on your PC? Thanks > No, if I put > [quoted text clipped - 136 lines] >>>>>>> >>>>>>> Thanks Yes it works on my computer, but you must not hold down the Ctrl key to drag down. Good luck Cimjet > Have you suceed to do it on your PC? > [quoted text clipped - 140 lines] >>>>>>>> >>>>>>>> Thanks Go to the link below, you will find a Spreadsheet with the Column A formatted with 1. http://www.savefile.com/projects/808625000 Good luck Cimjet > Have you suceed to do it on your PC? > [quoted text clipped - 140 lines] >>>>>>>> >>>>>>>> Thanks this is what I get... ERROR a.. Project not found "Cimjet" <cimjet(remove)300@sympatico.ca> wrote in message news:% 23tVUA7QlIHA.2268@TK2MSFTNGP02.phx.gbl... > Go to the link below, you will find a Spreadsheet with the Column A > formatted with 1. [quoted text clipped - 147 lines] >>>>>>>>> >>>>>>>>> Thanks > Hello, > [quoted text clipped - 15 lines] > > Thanks maybe you can try this: First,autofill 1 2 3 ... in column A Second, autofill . . . ... in column B Third, type "=A1&B1" in column C and then autofill. does this work? --------- Alex Yes that works, thanks.. If you know how to do it other way tell me also, please.. On Apr 2, 11:48 pm, "Borat" <vedro_@ hotmail.com> wrote: > Hello, > [quoted text clipped - 16 lines] > > Thanks maybe you can try this: First,autofill 1 2 3 ... in column A Second, autofill . . . ... in column B Third, type "=A1&B1" in column C and then autofill. does this work? --------- Alex |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.