Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-15-2014, 09:32 AM
bremen22 bremen22 is offline Creating a custom number format Windows 7 64bit Creating a custom number format Office 2010 64bit
Advanced Beginner
Creating a custom number format
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change from General Format to number format gbaker Excel 3 08-16-2013 01:04 PM
Custom Number Format for Chart deadrxn24 Word 4 03-18-2012 05:38 PM
Creating a custom number format creating a custom field and using it in a template Skarab Word 3 10-24-2011 03:33 AM
Creating a custom number format custom number format: change thousands separator Ward Excel 1 06-07-2011 08:18 PM
Creating a custom transition speed? watsonstudios PowerPoint 0 05-20-2011 08:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft