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
|