| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series, custom format question
I am designing some tickets.
I would like them to be numbered 001-100 and used Fill Series to do that. I'm using a custom format of "000" so all ticket #'s have 3 digits. I wold like to put Ticket # xxx" As soon as I added the "Ticket # " in front of the number, I lost the (ability to use the) custom format. Any suggestions? XL 2007 ...Lisa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
fill series, custom format question
Hi Lisa,
If I understand your problem correctly, all you need to do is wrap your text in double quotes. A custom format of "Ticket #" 000 will return Ticket # 001 when 1 is placed in a cell. HTH Martin "hamiltoncruiser" wrote in message ... I am designing some tickets. I would like them to be numbered 001-100 and used Fill Series to do that. I'm using a custom format of "000" so all ticket #'s have 3 digits. I wold like to put Ticket # xxx" As soon as I added the "Ticket # " in front of the number, I lost the (ability to use the) custom format. Any suggestions? XL 2007 ..Lisa |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
fill series, custom format question
Thank you!!
....Lisa On Nov 24, 4:32 pm, "MartinW" wrote: Hi Lisa, If I understand your problem correctly, all you need to do is wrap your text in double quotes. A custom format of "Ticket #" 000 will return Ticket # 001 when 1 is placed in a cell. HTH Martin "hamiltoncruiser" wrote in message ... I am designing some tickets. I would like them to be numbered 001-100 and used Fill Series to do that. I'm using a custom format of "000" so all ticket #'s have 3 digits. I wold like to put Ticket # xxx" As soon as I added the "Ticket # " in front of the number, I lost the (ability to use the) custom format. Any suggestions? XL 2007 ..Lisa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Format Question | Excel Discussion (Misc queries) | |||
| How do I create a custom fill series for dates? | Excel Discussion (Misc queries) | |||
| Custom fill series? | Excel Discussion (Misc queries) | |||
| Custom auto fill question | Excel Discussion (Misc queries) | |||
| I've created a custom fill series. Now I don't know how to use i. | Excel Discussion (Misc queries) | |||
Linear Mode
