LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Custom Format Question Telobamipada Excel Discussion (Misc queries) 11 October 18th 07 04:13 PM
How do I create a custom fill series for dates? Jeff Excel Discussion (Misc queries) 1 December 18th 06 03:28 AM
Custom fill series? martinkorner Excel Discussion (Misc queries) 15 June 25th 06 06:27 PM
Custom auto fill question method373 Excel Discussion (Misc queries) 2 December 24th 05 04:34 PM
I've created a custom fill series. Now I don't know how to use i. candybluevt Excel Discussion (Misc queries) 2 January 26th 05 08:48 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"