View Single Post
 
Old 01-15-2014, 09:32 AM
bremen22 bremen22 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Question Creating a custom number format

I am attempting to create a custom format and I am not having much luck. I have a suspense tracker sheet that I am developing and each task will have a number. I have found documentation that I should be able to simple enter the number of the task into the block and a special format will make it look how I want. What I want to see in my cell at the end of the day is

ADMIN 2014-0001

I have tried creating a custom number format, but Excel keeps giving me an error message that my format is invalid. I am typing

"ADMIN" yyyy-###0
Reply With Quote