Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-15-2014, 01:23 PM
BobBridges's Avatar
BobBridges BobBridges is offline Creating a custom number format Windows 7 64bit Creating a custom number format Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Yeah, I don't think I've ever seen date format characters ('y') combined with general numerals ('#' and '0'). I'm not surprised it won't work. You'll have to do this another way.

Ok, let's break this down into pieces. First, if you want ADMIN 2014-0001, then you don't want "###0" in the format string; that would get you ADMIN 2014-1 ... even if you got the other parts to work, I mean. So for that last part you're going to want '0000', not '###0'.

Second, how to combine this with the year? The value that's being formatted isn't a date, is it? I mean, if you want 2014-01-15 to be displayed as 2014-0001 and 2013-12-31 as 2013-0365, then we're talking about displaying a date in quasi-Julian format; that's one problem. But if you just have a bunch of numbers from 0 to 9999 and you want them all to appear as ADMIN 2014-nnnn then it can still be done, it's just a different problem.

One way would be to just make the custom format string "ADMIN 2014-"0000. That's great—simple and effective—but come next year you'll have change it. Is that all you need, or would you prefer something more complicated but flexible?
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 08:26 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