Increase the number of custom formats

[GuusKoppes]

Hi,

I am working on an excel tool for the calculation of ship weights using weight ratiocination.
I am trying to show text in a pivot table using the custom number format by applying custom formats like below to a cell in my pivot table.
[=100]"Hull structure, general"
The creation and application of these formats works fine using a macro but in my worksheet I am limited to adding 206 custom formats while i would like to add about 700.
If I try to add an additional format I get the error message "No more custom number formats can be added." I tried it on two different laptops one using Office 365 ProPlus and one using Office Professional Plus 2016

Is there a way to increase the number of custom formats that you can create?

PS. I know that it is possible to add the data to a data model and create a measure with the DAX formula concatenatex to show text in pivot table. But, it is sort of an interactive sheet, as a result it needs to be refreshed frequently and using the data model turned out to increase the refresh time very much.

 

[GraH]

This may be interesting for you No More Custom Formats Can Be Added (Microsoft Excel)

 

[GuusKoppes]

This may be interesting for you No More Custom Formats Can Be Added (Microsoft Excel)

Thanks for your reply! I did look at that post before but if I understand it correct this is more a solution to get rid of the custom formats in the workbook that are not used. In my case is purposely create these custom formats to display the text and therefore want to keep more than the allowed 206 at the moment.

 

[Michael M]

Have you read this

No More Custom Formats Can Be Added (Microsoft Excel)

If you make too many formatting changes to your workbook, you could end up with a situation where you cannot make any such additional changes. This can cause a bit of panic, but understanding the error is the first step to fixing it. (Tips.Net)

excel.tips.net

And this tutorial may help

Learning Excel Custom Number Formatting

Learn all about Excel's custom formatting - what is the rule for the custom formatting dialog box? How can you use it to hide zero values and much more.

www.xelplus.com

 

[GraH]

Thanks for your reply! I did look at that post before but if I understand it correct this is more a solution to get rid of the custom formats in the workbook that are not used. In my case is purposely create these custom formats to display the text and therefore want to keep more than the allowed 206 at the moment.

In that article is clearly explained that the limitation cause is lack of memory, not a limitation as such in Excel.

And in the reference added by Michael (nice pick up):
Excel 2016 is the first version, unlike previous Excel versions, that doesn’t have a custom format limit and won’t freeze or “crash” like previous versions. Earlier Excel versions do have a custom format limit – between 4,000 to 64,000 custom formats – depending upon the Excel version. You can find this limit for your Excel version on the web. It is a good idea to review that documentation for your version to understand your Excel version limitations, if any.

 

[GuusKoppes]

In that article is clearly explained that the limitation cause is lack of memory, not a limitation as such in Excel.

I read that as well, what memory do you think would be the limit?
It also says:
"but you must remember that limitation is theoretical—it is very possible that you will run out of space for custom formats long before you run out of memory."

So there must be some other reason as well I guess? Like I said i tested it on two different computers and different worksheets. Both 32bit and 64bit excel. Both resulted in a maximum of 206 custom formats that can be added.

 

[GuusKoppes]

Have you read this

No More Custom Formats Can Be Added (Microsoft Excel)

If you make too many formatting changes to your workbook, you could end up with a situation where you cannot make any such additional changes. This can cause a bit of panic, but understanding the error is the first step to fixing it. (Tips.Net)

excel.tips.net

And this tutorial may help

Learning Excel Custom Number Formatting

Learn all about Excel's custom formatting - what is the rule for the custom formatting dialog box? How can you use it to hide zero values and much more.

www.xelplus.com

Thanks for your reply! I read the first one already and took some time to look at the second one just now. The problem isn't the actual adding of the custom formats. I know what I want to do and can achieve that but only for the limited amount of 206 formats. I would like to increase that amount.

I did found something interesting though. In the second link it says:

"Excel 2016 is the first version, unlike previous Excel versions, that doesn’t have a custom format limit and won’t freeze or “crash” like previous versions. Earlier Excel versions do have a custom format limit – between 4,000 to 64,000 custom formats – depending upon the Excel version. You can find this limit for your Excel version on the web. It is a good idea to review that documentation for your version to understand your Excel version limitations, if any."

According to this I should not encounter this limit. So maybe the problem is somewhere else.
I will upload a test_sheet with two macros to create and delete the formats i am trying to make maybe someone can reproduce the problems that I encounter.

 

[jkpieterse]

Rather than discussing the limitations of custom formats, wouldn't it be more interesting if you told us what it is you are trying to achieve? perhaps a totally different approach is possible.

 

[GuusKoppes]

I hope this post shows in a clear way, first time posting code and excel ranges.
I have created two macros to duplicate the problem in a workbook with two sheets, Sheet1 and Sheet2.
Sheet1 has the first range Iposted below with the two columns. Sheet2 has the second range with only one column which is identical to the first column of sheet A.

The first macro will create a custom number format that will show the text in sheet1 column 2 instead of the actual number and apply the custom number format to the cell on sheet 2.
The second macro can be used to easily delete the custom formats created to avoid deleting them one by one.

Sub add_custom_format()
'adds a custom format to list of custom formats by using the first two columns in sheet1.
'the custom format is applied to the cell on sheet2
'goal is to convert the number to the corresponding description

last_row_new_ship_weights = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row

For jj = 1 To last_row_new_ship_weights

    Sheets("Sheet2").Cells(jj, 1).NumberFormat = "[=" & Sheets("Sheet1").Cells(jj, 1).Value & "]""" & Sheets("Sheet1").Cells(jj, 2).Value & """;"
    
Next jj
End Sub

Sub delete_custom_format()
'uses the same two columns on sheet1 to delete the custom number formats created with the add_custom_format macro

last_row_new_ship_weights = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row
On Error Resume Next
For jj = 1 To last_row_new_ship_weights

    ActiveWorkbook.DeleteNumberFormat NumberFormat:="[=" & Sheets("Sheet1").Cells(jj, 1).Value & "]""" & Sheets("Sheet1").Cells(jj, 2).Value & """;"
    
Next jj

End Sub

test_sheet_adding_custom_formats.xlsm
	A	B
1	0	GENERAL GUIDANCE AND ADMINISTRATION
2	10	COMBAT CAPABILITIES (OFFENSIVE AND DEFENSIVE)
3	11	AIR WEAPONS VS AIR TARGETS
4	12	AIR WEAPONS VS SURFACE TARGETS
5	13	AIR WEAPONS VS UNDERWATER TARGETS
6	14	SURFACE WEAPONS VS AIR TARGETS
7	15	SURFACE WEAPONS VS SURFACE TARGETS
8	16	SURFACE WEAPONS VS UNDERWATER TARGETS
9	17	UNDERWATER WEAPONS VS SURFACE TARGETS
10	18	UNDERWATER WEAPONS VS UNDERWATER TARGETS
11	20	STRATEGIC AND SPECIAL CAPABILITIES
12	21	SURFACE BASED DETERRENTS
13	22	UNDERWATER BASED DETERRENTS
14	23	AMPHIBIOUS WARFARE
15	24	MINE AND MINE COUNTERMEASURE WARFARE
16	25	INSHORE WARFARE
17	30	TACTICAL AND STRATEGIC OPERATION SUPPORT CAPABILITIES
18	31	COMMAND/CONTROL/COMMUNICATIONS
19	32	SURVEILLANCE/RECONNAISSANCE/INTELLIGENCE
20	33	ELECTRONIC WARFARE AND NUC/BIO/CHEMICAL DEFENSE
21	34	LOGISTICS/SEALIFT
22	35	OTHER SUPPORT
23	40	SHIP SYSTEM MANAGEMENT
24	41	PROJECT MANAGEMENT
25	42	GENERAL ADMINISTRATIVE REQUIREMENTS
26	43	LIFE CYCLE COSTING
27	44	SHIP OPERATION
28	45	CARE OF SHIP DURING CONSTRUCTION
29	50	SHIP SYSTEM PERFORMANCE
30	51	SHIP SYSTEM PERFORMANCE CONCEPTS
31	52	SHIP SUBSYSTEM PERFORMANCE CONCEPTS
32	53	SELECTED CONCEPTS
33	54	COMPONENT DEVELOPMENT
34	60	SUBSYSTEM CHARACTERISTICS
35	61	HULL STRUCTURE
36	62	PROPULSION PLANT
37	63	ELECTRIC PLANT
38	64	COMMAND AND SURVEILLANCE
39	65	AUXILIARY SYSTEMS
40	66	OUTFITTING
41	67	WEAPONS
42	68	INTEGRATION AND ENGINEERING
43	69	SHIP ASSEMBLY
44	70	GENERAL REQUIREMENTS FOR DESIGN AND CONSTRUCTION
45	71	ACCESS
46	72	SURVIVABILITY (FORMERLY SHOCK, SEE INCLUDES LISTING)
47	73	NOISE AND VIBRATION
48	74	CASTING ,WELDING, RIVETING, ALLIED PROCESSES (GENERAL)
49	75	THREADED FASTENERS STANDARDS
50	76	RELIABILITY AND MAINTAINABILITY
51	77	SAFETY
52	78	MATERIALS
53	79	SEAWORTHINESS
54	80	INTEGRATED LOGISTIC SUPPORT REQUIREMENTS
55	81	MAINTENANCE
56	82	SUPPORT AND TEST EQUIPMENT
57	83	SUPPLY SUPPORT
58	84	PACKAGING, HANDLING, STORAGE AND TRANSPORTATION
59	85	ENGINEERING DRAWINGS
60	86	TECHNICAL MANUALS AND OTHER DATA
61	87	FACILITIES
62	88	MANPOWER AND PERSONNEL
63	89	TRAINING AND TRAINING SUPPORT(FORMERLY TRAINING EQUIPMENT)
64	90	QUALITY ASSURANCE (FORMERLY QUALITY ASSURANCE REQT)
65	91	SHIP INSPECTIONS
66	92	SHIP TESTS
67	93	COMBAT SYSTEMS CHECKOUT
68	94	REGULAR SHIP TRIALS
69	95	WHOLE SHIP TESTING
70	96	MASS PROPERTIES CONTROL
71	97	INCLINING EXPERIMENT AND TRIM DIVE
72	98	MODELS AND MOCKUPS
73	99	PHOTOGRAPHS
74	100	HULL STRUCTURE, GENERAL
75	101	GENERAL ARRANGEMENT-STRUCTURAL DRAWINGS
76	110	SHELL AND SUPPORTING STRUCTURE
77	111	SHELL PLATING, SURFACE SHIP AND SUBMARINE PRESSURE HULL
78	112	SHELL PLATING, SUBMARINE NON-PRESSURE HULL
79	113	INNER BOTTOM
80	114	SHELL APPENDAGES
81	115	STANCHIONS
82	116	LONGIT. FRAMING, SURF SHIP AND SUBMARINE PRESSURE HULL
83	117	TRANSV. FRAMING, SURFACE SHIP AND SUBMARINE PRESSURE HULL
84	118	LONGITUDINAL AND TRANSVERSE SUBMARINE NON-PRESSURE HULL
85	119	LIFT SYSTEM FLEXIBLE SKIRTS AND SEALS
86	120	HULL STRUCTURAL BULKHEADS
87	121	LONGITUDINAL STRUCTURAL BULKHEADS
88	122	TRANSVERSE STRUCTURAL BULKHEADS
89	123	TRUNKS AND ENCLOSURES
90	124	BULKHEADS IN TORPEDO PROTECTION SYSTEM
91	125	SUBMARINE HARD TANKS
92	126	SUBMARINE SOFT TANKS
93	130	HULL DECKS
94	131	MAIN DECK
95	132	2ND DECK
96	133	3RD DECK
97	134	4TH DECK
98	135	5TH DECK AND DECKS BELOW
99	136	01 HULL DECK (FORECASTLE AND POOP DECKS)
100	137	02 HULL DECK
101	138	03 HULL DECK
102	139	04 HULL DECK AND HULL DECKS ABOVE
103	140	HULL PLATFORMS AND FLATS
104	141	1ST PLATFORM
105	142	2ND PLATFORM
106	143	3RD PLATFORM
107	144	4TH PLATFORM
108	145	5TH PLATFORM
109	149	FLATS
110	150	DECK HOUSE STRUCTURE
111	151	DECKHOUSE STRUCTURE TO FIRST LEVEL
112	152	1ST DECKHOUSE LEVEL
113	153	2ND DECKHOUSE LEVEL
114	154	3RD DECKHOUSE LEVEL
115	155	4TH DECKHOUSE LEVEL
116	156	5TH DECKHOUSE LEVEL
117	157	6TH DECKHOUSE LEVEL
118	158	7TH DECKHOUSE LEVEL
119	159	8TH DECKHOUSE LEVEL AND ABOVE
120	160	SPECIAL STRUCTURES
121	161	STRUCTURAL CASTINGS, FORGINGS, AND EQUIV. WELDMENTS
122	162	STACKS AND MACKS (COMBINED STACK AND MAST)
123	163	SEA CHESTS
124	164	BALLISTIC PLATING
125	165	SONAR DOMES
126	166	SPONSONS
127	167	HULL STRUCTURAL CLOSURES
128	168	DECKHOUSE STRUCTURAL CLOSURES
129	169	SPECIAL PURPOSE CLOSURES AND STRUCTURES
130	170	MASTS, KINGPOSTS, AND SERVICE PLATFORMS
131	171	MASTS, TOWERS, TETRAPODS
132	172	KINGPOSTS AND SUPPORT FRAMES
133	179	SERVICE PLATFORMS
134	180	FOUNDATIONS
135	181	HULL STRUCTURE FOUNDATIONS
136	182	PROPULSION PLANT FOUNDATIONS
137	183	ELECTRIC PLANT FOUNDATIONS
138	184	COMMAND AND SURVEILLANCE FOUNDATIONS
139	185	AUXILIARY SYSTEMS FOUNDATIONS
140	186	OUTFIT AND FURNISHINGS FOUNDATIONS
141	187	ARMAMENT FOUNDATIONS
142	188	COMMON FOUNDATIONS
143	190	SPECIAL PURPOSE SYSTEMS
144	191	BALLAST, FIXED OR FLUID, AND BUOYANCY UNITS
145	192	COMPARTMENT TESTING
146	195	ERECTION OF SUB SECTIONS (PROGRESS REPORT ONLY)
147	196	WELD TOLERANCE
148	197	MATERIAL TOLERANCE
149	198	FREE FLOODING LIQUIDS
150	199	HULL REPAIR PARTS AND SPECIAL TOOLS
151	200	PROPULSION PLANT, GENERAL
152	201	GENERAL ARRANGEMENT - PROPULSION DRAWINGS
153	202	MACHINERY PLANT CENTRAL CONTROL SYSTEMS
154	210	ENERGY GENERATING SYSTEM (NUCLEAR)
155	211	(RESERVED)
156	212	NUCLEAR STEAM GENERATOR
157	213	REACTORS
158	214	REACTOR COOLANT SYSTEM
159	215	REACTOR COOLANT SERVICE SYSTEMS
160	216	REACTOR PLANT AUXILIARY SYSTEMS
161	217	NUCLEAR POWER CONTROL AND INSTRUMENTATION
162	218	RADIATION SHIELDING (PRIMARY)
163	219	RADIATION SHIELDING (SECONDARY)
164	220	ENERGY GENERATING SYSTEM (NON-NUCLEAR)
165	221	PROPULSION BOILERS
166	222	GAS GENERATORS
167	223	MAIN PROPULSION BATTERIES
168	224	MAIN PROPULSION FUEL CELLS
169	230	PROPULSION UNITS
170	231	PROPULSION STEAM TURBINES
171	232	PROPULSION STEAM ENGINES
172	233	PROPULSION INTERNAL COMBUSTION ENGINES
173	234	PROPULSION GAS TURBINES
174	235	ELECTRIC PROPULSION
175	236	SELF-CONTAINED PROPULSION SYSTEMS
176	237	AUXILIARY PROPULSION DEVICES
177	238	SECONDARY PROPULSION (SUBMARINES)
178	239	EMERGENCY PROPULSION
179	240	TRANSMISSION AND PROPULSOR SYSTEMS
180	241	PROPULSION REDUCTION GEARS
181	242	PROPULSION CLUTCHES AND COUPLINGS
182	243	PROPULSION SHAFTING
183	244	PROPULSION SHAFT BEARINGS
184	245	PROPULSORS
185	246	PROPULSOR SHROUDS AND DUCTS
186	247	WATER JET PROPULSORS
187	248	LIFT SYSTEM FANS AND DUCTING
188	249	PODDED PROPULSORS
189	250	PROPULSION SUPPORT SYS. (EXCEPT FUEL AND LUBE OIL)
190	251	COMBUSTION AIR SYSTEM
191	252	PROPULSION CONTROL SYSTEM
192	253	MAIN STEAM PIPING SYSTEM
193	254	CONDENSERS AND AIR EJECTORS
194	255	FEED AND CONDENSATE SYSTEM
195	256	CIRCULATING AND COOLING SEA WATER SYSTEM
196	258	HP STEAM DRAIN SYSTEM
197	259	UPTAKES (INNER CASING)
198	260	PROPULSION SUPPORT SYSTEMS (FUEL AND LUBE OIL)
199	261	FUEL SERVICE SYSTEM
200	262	MAIN PROPULSION LUBE OIL SYSTEM
201	263	SHAFT LUBE OIL SYSTEM (SUBMARINES)
202	264	LUBE OIL FILL, TRANSFER, AND PURIFICATION
203	290	SPECIAL PURPOSE SYSTEMS
204	298	PROPULSION PLANT OPERATING FLUIDS
205	299	PROPULSION PLANT REPAIR PARTS AND SPECIAL TOOLS
206	300	ELECTRIC PLANT, GENERAL
207	301	GENERAL ARRANGEMENT-ELECTRICAL DRAWINGS
208	302	MOTORS AND ASSOCIATED EQUIPMENT
209	303	PROTECTIVE DEVICES
210	304	ELECTRIC CABLES
211	305	ELECTRICAL DESIGNATING AND MARKING
212	310	ELECTRIC POWER GENERATION
213	311	SHIP SERVICE POWER GENERATION
214	312	EMERGENCY GENERATORS
215	313	BATTERIES AND SERVICE FACILITIES
216	314	POWER CONVERSION EQUIPMENT
217	320	POWER DISTRIBUTION SYSTEMS
218	321	SHIP SERVICE POWER CABLE
219	322	EMERGENCY POWER CABLE SYSTEM
220	323	CASUALTY POWER CABLE SYSTEM
221	324	SWITCHGEAR AND PANELS
222	325	ARC FAULT DETECTOR (AFD) SYSTEMS
223	330	LIGHTING SYSTEM
224	331	LIGHTING DISTRIBUTION
225	332	LIGHTING FIXTURES
226	340	POWER GENERATION SUPPORT SYSTEMS
227	341	SSTG LUBE OIL
228	342	DIESEL SUPPORT SYSTEMS
229	343	TURBINE SUPPORT SYSTEMS
230	390	SPECIAL PURPOSE SYSTEMS
231	398	ELECTRIC PLANT OPERATING FLUIDS
232	399	ELECTRIC PLANT REPAIR PARTS AND SPECIAL TOOLS
233	400	COMMAND AND SURVEILLANCE, GENERAL
234	401	GENERAL ARRANGEMENT - COMMAND AND SURVEILLANCE
235	402	SECURITY REQUIREMENTS
236	403	PERSONNEL SAFETY
237	404	RADIO FREQUENCY TRANSMISSION LINES
238	405	ANTENNA REQUIREMENTS
239	406	GROUNDING AND BONDING
240	407	ELECTROMAGNETIC INTERFERENCE REDUCTION (EMI)
241	408	SYSTEM TEST REQUIREMENTS
242	409	COMBAT SYSTEM GENERAL REQUIREMENTS
243	410	COMMAND AND CONTROL SYSTEMS
244	411	DATA DISPLAY GROUP
245	412	DATA PROCESSING GROUP
246	413	DIGITAL DATA SWITCHBOARDS
247	414	INTERFACE EQUIPMENT
248	415	DIGITAL DATA COMMUNICATIONS
249	417	COMMAND AND CONTROL ANALOG SWITCHBOARDS
250	420	NAVIGATION SYSTEMS
251	421	NON-ELECTRICAL/NON-ELECTRONIC NAVIGATION AIDS
252	422	ELECTRICAL NAVIGATION AIDS (INCL NAVIG. LIGHTS)
253	423	ELECTRONIC NAVIGATION SYSTEMS, RADIO
254	424	ELECTRONIC NAVIGATION SYSTEMS, ACOUSTICAL
255	425	PERISCOPES
256	426	ELECTRICAL NAVIGATION SYSTEMS
257	427	INERTIAL NAVIGATION SYSTEMS
258	428	NAVIGATION CONTROL MONITORING
259	430	INTERIOR COMMUNICATIONS
260	431	SWITCHBOARDS FOR INTERIOR COMMUNICATION SYSTEMS
261	432	TELEPHONE SYSTEMS
262	433	ANNOUNCING SYSTEMS
263	434	ENTERTAINMENT AND TRAINING SYSTEMS
264	435	VOICE TUBES AND MESSAGE PASSING SYSTEMS
265	436	ALARM, SAFETY, AND WARNING SYSTEMS
266	437	INDICATING, ORDER, AND METERING SYSTEMS
267	438	CONSOLIDATED CONTROL AND DISPLAY SYSTEMS
268	439	RECORDING AND TELEVISION SYSTEMS
269	440	TESTING, INTEGRATED RADIO SYSTEMS
270	441	RADIO SYSTEMS
271	442	UNDERWATER SYSTEMS
272	443	VISUAL AND AUDIBLE COMMUNICATION SYSTEMS
273	444	TELEMETRY SYSTEMS
274	445	TELETYPE AND FACSIMILE SYSTEMS
275	446	SECURITY EQUIPMENT SYSTEMS
276	450	SURVEILLANCE SYSTEMS, SURFACE AND AIR
277	451	SURFACE SURVEILLANCE RADAR SYSTEMS
278	452	AIR SEARCH RADAR (2D)
279	453	AIR SEARCH RADAR (3D)
280	454	AIRCRAFT CONTROL APPROACH RADAR
281	455	IDENTIFICATION SYSTEMS (IFF)
282	456	MULTIPLE MODE/FUNCTION RADAR
283	457	INFRARED SURVEILLANCE & TRACKING SYSTEMS
284	458	AUTOMATIC DETECTION & TRACKING SYSTEMS
285	459	SPACE VEHICLE ELECTRONIC TRACKING
286	460	SURVEILLANCE SYSTEMS (UNDERWATER)
287	461	ACTIVE SONAR
288	462	PASSIVE SONAR
289	463	MULTIPLE MODE SONAR
290	464	CLASSIFICATION SONAR
291	465	BATHYTHERMOGRAPH
292	466	MULTI-PURPOSE SHIP EQUIPMENT SYSTEMS
293	467	OWN NOISE MONITORING SYSTEMS
294	470	COUNTERMEASURE SYSTEMS
295	471	ACTIVE EW (INCL COMBINATION ACTIVE/PASSIVE)
296	472	PASSIVE ECM
297	473	UNDERWATER COUNTERMEASURES
298	474	DECOY SYSTEMS
299	475	DEGAUSSING SYSTEMS
300	476	MINE COUNTERMEASURE SYSTEMS
301	477	SIGNATURE MANAGEMENT SYSTEMS
302	480	FIRE CONTROL SYSTEMS
303	481	GUN FIRE CONTROL SYSTEMS
304	482	MISSILE FIRE CONTROL SYSTEMS
305	483	UNDERWATER FIRE CONTROL SYSTEMS
306	484	INTEGRATED FIRE CONTROL SYSTEMS
307	489	WEAPON SYSTEMS SWITCHBOARDS
308	490	SPECIAL PURPOSE SYSTEMS
309	491	ELECTRONIC TEST, CHECKOUT, AND MONITORING EQUIPMENT
310	492	FLIGHT CONTROL AND INSTRUMENT LANDING SYSTEMS
311	493	AUTOMATED DATA PROCESSING SYSTEMS (NON-COMBAT)
312	494	METEOROLOGICAL SYSTEMS
313	495	SPECIAL PURPOSE INTELLIGENCE SYSTEMS
314	498	COMMAND AND SURVEILLANCE OPERATING FLUIDS
315	499	COMMAND AND SURV. REPAIR PARTS AND SPECIAL TOOLS
316	500	AUXILIARY SYSTEMS, GENERAL
317	501	GENERAL ARRANGEMENT-AUXILIARY SYSTEMS DRAWINGS
318	502	AUXILIARY MACHINERY
319	503	PUMPS
320	504	INSTRUMENTS AND INSTRUMENT BOARDS
321	505	GENERAL PIPING REQUIREMENTS
322	506	OVERFLOWS, AIR ESCAPES, AND SOUNDING TUBES
323	507	MACHINERY AND PIPING DESIGNATION AND MARKING
324	508	THERMAL INSULATION FOR PIPING AND MACHINERY
325	509	THERMAL INSULATION FOR VENT AND A/C DUCTS
326	510	CLIMATE CONTROL
327	511	COMPARTMENT HEATING SYSTEM
328	512	VENTILATION SYSTEM
329	513	MACHINERY SPACE VENTILATION SYSTEM
330	514	AIR CONDITIONING SYSTEM
331	515	AIR REVITALIZATION SYSTEMS (SUBMARINES)
332	516	REFRIGERATION SYSTEM
333	517	AUXILIARY BOILERS AND OTHER HEAT SOURCES
334	520	SEA WATER SYSTEMS
335	521	FIREMAIN AND FLUSHING (SEA WATER) SYSTEM
336	522	SPRINKLER SYSTEM
337	523	WASHDOWN SYSTEM
338	524	AUXILIARY SEA WATER SYSTEM
339	526	SCUPPERS AND DECK DRAINS
340	527	FIREMAIN ACTUATED SERVICES - OTHER
341	528	PLUMBING DRAINAGE
342	529	DRAINAGE AND BALLASTING SYSTEM
343	530	FRESH WATER SYSTEMS
344	531	DISTILLING PLANT
345	532	COOLING WATER
346	533	POTABLE WATER
347	534	AUXILIARY STEAM AND DRAINS WITHIN MACHINERY BOX
348	535	AUXILIARY STEAM AND DRAINS OUTSIDE MACHINERY BOX
349	536	AUXILIARY FRESH WATER COOLING
350	537	FRESH WATER FIREFIGHTING SYSTEMS
351	540	FUELS AND LUBRICANTS, HANDLING AND STORAGE
352	541	SHIP FUEL AND FUEL COMPENSATING SYSTEM
353	542	AVIATION AND GENERAL PURPOSE FUELS
354	543	AVIATION AND GENERAL PURPOSE LUBRICATING OIL
355	544	LIQUID CARGO
356	545	TANK HEATING
357	546	AUXILIARY LUBRICATION SYSTEMS
358	549	SPECIAL FUEL AND LUBRICANTS, HANDLING AND STOWAGE
359	550	AIR, GAS, AND MISCELLANEOUS FLUID SYSTEMS
360	551	COMPRESSED AIR SYSTEMS
361	552	COMPRESSED GASES
362	553	O2 N2 SYSTEM
363	554	MAIN BALLAST TANK BLOW AND LIST CONTROL SYSTEM
364	555	FIRE EXTINGUISHING SYSTEMS
365	556	HYDRAULIC FLUID SYSTEM
366	557	LIQUID GASES, CARGO
367	558	SPECIAL PIPING SYSTEMS
368	560	SHIP CONTROL SYSTEMS
369	561	STEERING AND DIVING CONTROL SYSTEMS
370	562	RUDDER
371	563	HOVERING AND DEPTH CONTROL (SUBMARINE)
372	564	TRIM AND DRAIN SYSTEMS (SUBMARINES)
373	565	TRIM AND HEEL SYSTEMS (SURFACE SHIPS)
374	566	DIVING PLANES AND STABILIZING FINS (SUBMARINES)
375	567	STRUT AND FOIL SYSTEMS
376	568	MANEUVERING SYSTEMS
377	570	REPLENISHMENT SYSTEMS
378	571	REPLENISHMENT-AT-SEA SYSTEMS
379	572	SHIP STORES AND EQUIPMENT HANDLING SYSTEMS
380	573	CARGO HANDLING SYSTEMS
381	574	VERTICAL REPLENISHMENT SYSTEMS
382	575	VEHICLE HANDLING AND STOWAGE SYSTEMS
383	580	MECHANICAL HANDLING SYSTEMS
384	581	ANCHOR HANDLING AND STOWAGE SYSTEMS
385	582	MOORING AND TOWING SYSTEMS
386	583	BOATS, BOAT HANDLING AND STOWAGE SYSTEMS
387	584	LANDING CRAFT HANDLING AND STOWAGE SYSTEMS
388	585	ELEVATING AND RETRACTING GEAR
389	586	AIRCRAFT RECOVERY SUPPORT SYSTEMS
390	587	AIRCRAFT LAUNCH SUPPORT SYSTEMS
391	588	AIRCRAFT HANDLING, SERVICING AND STOWAGE
392	589	MISCELLANEOUS MECHANICAL HANDLING SYSTEMS
393	590	SPECIAL PURPOSE SYSTEMS
394	591	SCIENTIFIC AND OCEAN ENGINEERING SYSTEMS
395	592	SWIMMER AND DIVER SUPPORT AND PROTECTION SYSTEMS
396	593	ENVIRONMENTAL POLLUTION CONTROL SYSTEMS
397	594	SUBMARINE RESCUE, SALVAGE, AND SURVIVAL SYSTEMS
398	595	TOWING, LAUNCHING AND HANDLING FOR UNDERWATER SYS.
399	596	HANDLING SYS. FOR DIVER AND SUBMERSIBLE VEHICLES
400	597	SALVAGE SUPPORT SYSTEMS
401	598	AUXILIARY SYSTEMS OPERATING FLUIDS
402	599	AUXILIARY SYSTEMS REPAIR PARTS AND TOOLS
403	600	OUTFIT AND FURNISHINGS, GENERAL
404	601	GENERAL ARRANGEMENT - OUTFIT AND FURN. DRAWINGS
405	602	HULL DESIGNATING AND MARKING
406	603	DRAFT MARKS
407	604	LOCKS, KEYS, AND TAGS
408	605	RODENT AND VERMIN PROOFING
409	610	SHIP FITTINGS
410	611	HULL FITTINGS
411	612	RAILS, STANCHIONS, AND LIFELINES
412	613	RIGGING AND CANVAS
413	620	HULL COMPARTMENTATION
414	621	NON-STRUCTURAL BULKHEADS
415	622	FLOOR PLATES AND GRATINGS
416	623	LADDERS
417	624	NON-STRUCTURAL CLOSURES
418	625	AIRPORTS, FIXED PORTLIGHTS, AND WINDOWS
419	630	PRESERVATIVES AND COVERINGS
420	631	PAINTING
421	632	ZINC AND METALLIC COATINGS
422	633	CATHODIC PROTECTION
423	634	DECK COVERING
424	635	HULL INSULATION
425	636	HULL DAMPING
426	637	SHEATHING
427	638	REFRIGERATED SPACES
428	639	RADIATION SHIELDING
429	640	LIVING SPACES
430	641	OFFICER BERTHING AND MESSING SPACES
431	642	NONCOMMISSIONED OFFICER BERTHING AND MESSING SPACES
432	643	ENLISTED PERSONNEL BERTHING AND MESSING SPACES
433	644	SANITARY SPACES AND FIXTURES
434	645	LEISURE AND COMMUNITY SPACES
435	650	SERVICE SPACES
436	651	COMMISSARY SPACES
437	652	MEDICAL SPACES
438	653	DENTAL SPACES
439	654	UTILITY SPACES
440	655	LAUNDRY SPACES
441	656	TRASH DISPOSAL SPACES
442	660	WORKING SPACES
443	661	OFFICES
444	662	MACHINERY CONTROL CENTERS FURNISHINGS
445	663	ELECTRONICS CONTROL CENTERS FURNISHINGS
446	664	DAMAGE CONTROL STATIONS
447	665	WORKSHOPS, LABS, TEST AREAS (INCL PORTABLE TOOLS, EQUIP)
448	670	STOWAGE SPACES
449	671	LOCKERS AND SPECIAL STOWAGE
450	672	STOREROOMS AND ISSUE ROOMS
451	673	CARGO STOWAGE
452	680	TRIALS AND CERTIFICATION
453	681	TRIALS AND CERTIFICATION (FORMERLY 868)
454	690	SPECIAL PURPOSE SYSTEMS
455	691	SPECIAL HULL TREATMENT
456	698	OUTFIT AND FURNISHINGS OPERATING FLUIDS
457	699	OUTFIT AND FURNISH. REPAIR PARTS AND SPECIAL TOOLS
458	700	ARMAMENT, GENERAL
459	701	GENERAL ARRANGEMENT - WEAPONRY SYSTEMS
460	702	ARMAMENT INSTALLATIONS
461	703	WEAPONS HANDLING AND STOWAGE, GENERAL
462	710	GUNS AND AMMUNITION
463	711	GUNS
464	712	AMMUNITION HANDLING
465	713	AMMUNITION STOWAGE
466	720	MISSILES AND ROCKETS
467	721	LAUNCHING DEVICES (MISSILES AND ROCKETS)
468	722	MISSILE, ROCKET, AND GUIDANCE CAPSULE HANDLING SYS.
469	723	MISSILE AND ROCKET STOWAGE
470	724	MISSILE HYDRAULICS
471	725	MISSILE GAS
472	726	MISSILE COMPENSATING
473	727	MISSILE LAUNCHER CONTROL
474	728	MISSILE HEATING, COOLING, TEMPERATURE CONTROL
475	729	MISSILE MONITORING, TEST AND ALIGNMENT
476	730	MINES
477	731	MINE LAUNCHING DEVICES
478	732	MINE HANDLING
479	733	MINE STOWAGE
480	740	DEPTH CHARGES
481	741	DEPTH CHARGE LAUNCHING DEVICES
482	742	DEPTH CHARGE HANDLING
483	743	DEPTH CHARGE STOWAGE
484	750	TORPEDOES
485	751	TORPEDO TUBES
486	752	TORPEDO HANDLING
487	753	TORPEDO STOWAGE
488	754	SUBMARINE TORPEDO EJECTION
489	755	TORPEDO SUPPORT, TEST AND ALIGNMENT
490	760	SMALL ARMS AND PYROTECHNICS
491	761	SMALL ARMS AND PYROTECHNIC LAUNCHING DEVICES
492	762	SMALL ARMS AND PYROTECHNIC HANDLING
493	763	SMALL ARMS AND PYROTECHNIC STOWAGE
494	770	CARGO MUNITIONS
495	772	CARGO MUNITIONS HANDLING
496	773	CARGO MUNITIONS STOWAGE
497	780	AIRCRAFT RELATED WEAPONS
498	782	AIRCRAFT RELATED WEAPONS HANDLING
499	783	AIRCRAFT RELATED WEAPONS STOWAGE
500	784	AIRCRAFT RELATED WEAPONS ELEVATORS, UPPER STAGES
501	785	AIRCRAFT RELATED WEAPONS ELEVATORS, LOWER STAGES
502	786	AIRCRAFT RELATED WEAPONS, HYDRAULICS
503	790	SPECIAL PURPOSE SYSTEMS
504	792	SPECIAL WEAPONS HANDLING
505	793	SPECIAL WEAPONS STOWAGE
506	797	MISCELLANEOUS ORDNANCE SPACES
507	798	ARMAMENT OPERATING FLUIDS
508	799	ARMAMENT REPAIR PARTS AND SPECIAL TOOLS
509	800	INTEGRATION/ENGINEERING (SHIPBUILDER RESPONSE)
510	801	SHIPBUILDERS INFORMATION DRAWINGS
511	802	CONTRACT DRAWINGS
512	803	STANDARD DRAWINGS
513	804	TYPE DRAWINGS
514	806	STUDY DRAWINGS
515	807	INSTALLATION CONTROL DRAWINGS
516	808	INTERFACE CONTROL DRAWINGS
517	810	PRODUCTION ENGINEERING
518	811	CONFIGURATION MANAGEMENT (DELETED - SEE 8612 & 8613)
519	812	CHANGE PROPOSALS, SCOPING AND SHIPCHECKING
520	813	PLANNING AND PRODUCTION CONTROL
521	820	SPECIAL DRAWINGS FOR NUCLEAR PROPULSION SYSTEMS
522	830	DESIGN SUPPORT
523	831	CONSTRUCTION DRAWINGS
524	832	SPECIFICATIONS
525	833	MASS PROPERTIES ENGINEERING
526	834	COMPUTER PROGRAMS
527	835	ENGINEERING CALCULATIONS
528	836	MODELS AND MOCKUPS
529	837	PHOTOGRAPHS
530	838	DESIGN/ENGINEERING LIAISON
531	839	LOFTING
532	840	QUALITY ASSURANCE
533	841	TESTS AND INSPECTION, CRITERIA, AND PROCEDURES
534	842	TRIALS AGENDA PREPARATION, DATA COLLECTION AND ANAL.
535	843	INCLINING EXPERIMENT AND TRIM DIVE
536	844	COMBAT SYSTEMS CHECKOUT CRITERIA AND PROCEDURES
537	845	CERTIFICATION STANDARDS
538	850	INTEGRATED LOGISTIC SUPPORT ENGINEERING
539	851	MAINTENANCE
540	852	SUPPORT AND TEST EQUIPMENT
541	853	SUPPLY SUPPORT
542	854	TRANSPORTATION
543	855	ENGINEERING DRAWINGS AND SPECIFICATIONS
544	856	TECHNICAL MANUALS AND OTHER DATA
545	857	FACILITIES
546	858	PERSONNEL AND TRAINING
547	859	TRAINING EQUIPMENT
548	880	AUTHORIZED REPAIR PLANNING
549	881	FUNDS
550	890	SPECIAL PURPOSE ITEMS
551	891	SAFETY
552	892	HUMAN FACTORS
553	893	STANDARDIZATION
554	894	VALUE ENGINEERING
555	895	RELIABILITY AND MAINTAINABILITY
556	896	DATA MANAGEMENT
557	897	PROJECT MANAGEMENT
558	900	SHIP ASSEMBLY AND SUPPORT SERVICES
559	901	901 THRU 979 RESERVED FOR IDENT. OF ASSEMBLIES
560	980	TESTING, RELIEF VALVES
561	981	INSURANCE
562	982	TRIALS
563	983	DELIVERY
564	984	OPEN AND INSPECT (CONVERSIONS ONLY)
565	985	FIRE AND FLOODING PROTECTION
566	986	TESTS AND INSPECTION
567	987	WEIGHING AND RECORDING
568	988	CONTRACT DATA REQUIREMENTS (ADMINISTRATION)
569	989	FITTING-OUT
570	990	CONSTRUCTION SUPPORT
571	991	STAGING, SCAFFOLDING, AND CRIBBING
572	992	TEMPORARY UTILITIES AND SERVICES
573	993	MATERIAL HANDLING AND REMOVAL
574	994	CLEANING SERVICES
575	995	MOLDS AND TEMPLATES, JIGS, FIXTURES, AND SPEC. TOOLS
576	996	LAUNCHING
577	997	DRYDOCKING
578	F00	LOADS (FULL LOAD CONDITION)
579	F10	SHIPS FORCE, AMPHIB. FORCE, TROOPS AND PASSENGERS
580	F11	SHIPS OFFICERS
581	F12	SHIPS NONCOMMISSIONED OFFICERS
582	F13	SHIPS ENLISTED MEN
583	F14	MARINES
584	F15	TROOPS
585	F16	AIR WING PERSONNEL
586	F19	OTHER PERSONNEL
587	F20	MISSION RELATED EXPENDABLES AND SYSTEMS
588	F21	SHIP AMMUNITION (FOR USE BY SHIP ON WHICH STOWED)
589	F22	ORDNANCE DELIVERY SYSTEMS AMMUNITION
590	F23	ORDNANCE DELIVERY SYSTEMS
591	F24	ORDNANCE REPAIR PARTS (SHIP AMMO)
592	F25	ORDNANCE REPAIR PARTS (ORDNANCE DELIVERY SYS. AMMO)
593	F26	ORDNANCE DELIVERY SYSTEMS SUPPORT EQUIPMENT
594	F29	SPECIAL MISSION RELATED SYSTEMS AND EXPENDABLES
595	F30	STORES
596	F31	PROVISIONS AND PERSONNEL STORES
597	F32	GENERAL STORES
598	F33	MARINES STORES (FOR SHIP'S COMPLEMENT)
599	F39	SPECIAL STORES
600	F40	FUELS AND LUBRICANTS
601	F41	DIESEL FUEL
602	F42	JP-5
603	F43	GASOLINE
604	F44	DISTILLATE FUEL
605	F45	NAVY STANDARD FUEL OIL (NSFO)
606	F46	LUBRICATING OIL
607	F49	SPECIAL FUELS AND LUBRICANTS
608	F50	LIQUIDS AND GASES (NON FUEL TYPE)
609	F51	SEA WATER
610	F52	FRESH WATER
611	F53	RESERVE FEED WATER
612	F54	HYDRAULIC FLUID
613	F55	SANITARY TANK LIQUID
614	F56	GAS (NON FUEL TYPE)
615	F59	MISCELLANEOUS LIQUIDS (NON FUEL TYPE)
616	F60	CARGO
617	F61	CARGO, ORDNANCE AND ORDNANCE DELIVERY SYSTEMS
618	F62	CARGO, STORES
619	F63	CARGO, FUELS AND LUBRICANTS
620	F64	CARGO, LIQUIDS (NON FUEL TYPE)
621	F65	CARGO, CRYOGENIC AND LIQUIFIED GAS
622	F66	CARGO, AMPHIBIOUS ASSAULT SYSTEMS
623	F67	CARGO, GASES
624	F69	CARGO, MISCELLANEOUS
625	F70	SEA WATER BALLAST (SUBMARINES)
626	F71	MAIN BALLAST WATER (SUBMARINES)
627	F72	VARIABLE BALLAST WATER (SUBMARINES)
628	F73	RESIDUAL WATER (SUBMARINES)
629	M00	MARGINS
630	M10	CONTRACTOR CONTROLLED MARGINS
631	M11	DESIGN AND BUILDING MARGIN
632	M12	BUILDING MARGIN (RESERVED)
633	M20	GOVERNMENT CONTROLLED MARGIN (SURFACE SHIP)
634	M21	PRELIMINARY DESIGN MARGIN (SURFACE SHIP)
635	M22	CONTRACT DESIGN MARGIN (SURFACE SHIP)
636	M23	CONTRACT MODIFICATION MARGIN (SURFACE SHIP)
637	M24	GEM MARGIN (SURFACE SHIP)
638	M25	FUTURE GROWTH MARGIN (SURFACE SHIP)
639	M26	SERVICE LIFE MARGIN (SURFACE SHIP)
640	M27	NUCLEAR MACHINERY MARGIN (SURFACE SHIP)
641	M30	GOVERNMENT CONTROLLED MARGIN STATUS (SUBMARINES)
642	M31	PRELIMINARY DESIGN MARGIN (SUBMARINE)
643	M32	CONTRACT DESIGN MARGIN (SUBMARINE)
644	M33	NAVSHIPS DEVELOPMENT MARGIN (SUBMARINE)
645	M34	NUCLEAR MACHINERY MARGIN (SUBMARINE)
646	M35	FUTURE GROWTH MARGIN (SUBMARINE)
647	M36	STABILITY LEAD STATUS (SUBMARINE)
648	M37	TRIMMING LEAD STATUS (SUBMARINE)
649	M40	BALLAST STATUS (SUBMARINE)
650	M41	LEAD, INTERNAL (SUBMARINE)
651	M42	LEAD, EXTERNAL (SUBMARINE)
652	M43	LEAD, MET (SUBMARINE)
653	M44	STEEL, INTERNAL (SUBMARINE)
654	M45	STEEL, EXTERNAL (SUBMARINE)
655	M46	STEEL, MBT (SUBMARINE)
656	M47	LEAD CORRECTION, MET (SUBMARINE)
657	M48	LEAD CORRECTION, OTHER THEN MET (SUBMARINE)
Sheet1

test_sheet_adding_custom_formats.xlsm
	A
1	0
2	10
3	11
4	12
5	13
6	14
7	15
8	16
9	17
10	18
11	20
12	21
13	22
14	23
15	24
16	25
17	30
18	31
19	32
20	33
21	34
22	35
23	40
24	41
25	42
26	43
27	44
28	45
29	50
30	51
31	52
32	53
33	54
34	60
35	61
36	62
37	63
38	64
39	65
40	66
41	67
42	68
43	69
44	70
45	71
46	72
47	73
48	74
49	75
50	76
51	77
52	78
53	79
54	80
55	81
56	82
57	83
58	84
59	85
60	86
61	87
62	88
63	89
64	90
65	91
66	92
67	93
68	94
69	95
70	96
71	97
72	98
73	99
74	100
75	101
76	110
77	111
78	112
79	113
80	114
81	115
82	116
83	117
84	118
85	119
86	120
87	121
88	122
89	123
90	124
91	125
92	126
93	130
94	131
95	132
96	133
97	134
98	135
99	136
100	137
101	138
102	139
103	140
104	141
105	142
106	143
107	144
108	145
109	149
110	150
111	151
112	152
113	153
114	154
115	155
116	156
117	157
118	158
119	159
120	160
121	161
122	162
123	163
124	164
125	165
126	166
127	167
128	168
129	169
130	170
131	171
132	172
133	179
134	180
135	181
136	182
137	183
138	184
139	185
140	186
141	187
142	188
143	190
144	191
145	192
146	195
147	196
148	197
149	198
150	199
151	200
152	201
153	202
154	210
155	211
156	212
157	213
158	214
159	215
160	216
161	217
162	218
163	219
164	220
165	221
166	222
167	223
168	224
169	230
170	231
171	232
172	233
173	234
174	235
175	236
176	237
177	238
178	239
179	240
180	241
181	242
182	243
183	244
184	245
185	246
186	247
187	248
188	249
189	250
190	251
191	252
192	253
193	254
194	255
195	256
196	258
197	259
198	260
199	261
200	262
201	263
202	264
203	290
204	298
205	299
206	300
207	301
208	302
209	303
210	304
211	305
212	310
213	311
214	312
215	313
216	314
217	320
218	321
219	322
220	323
221	324
222	325
223	330
224	331
225	332
226	340
227	341
228	342
229	343
230	390
231	398
232	399
233	400
234	401
235	402
236	403
237	404
238	405
239	406
240	407
241	408
242	409
243	410
244	411
245	412
246	413
247	414
248	415
249	417
250	420
251	421
252	422
253	423
254	424
255	425
256	426
257	427
258	428
259	430
260	431
261	432
262	433
263	434
264	435
265	436
266	437
267	438
268	439
269	440
270	441
271	442
272	443
273	444
274	445
275	446
276	450
277	451
278	452
279	453
280	454
281	455
282	456
283	457
284	458
285	459
286	460
287	461
288	462
289	463
290	464
291	465
292	466
293	467
294	470
295	471
296	472
297	473
298	474
299	475
300	476
301	477
302	480
303	481
304	482
305	483
306	484
307	489
308	490
309	491
310	492
311	493
312	494
313	495
314	498
315	499
316	500
317	501
318	502
319	503
320	504
321	505
322	506
323	507
324	508
325	509
326	510
327	511
328	512
329	513
330	514
331	515
332	516
333	517
334	520
335	521
336	522
337	523
338	524
339	526
340	527
341	528
342	529
343	530
344	531
345	532
346	533
347	534
348	535
349	536
350	537
351	540
352	541
353	542
354	543
355	544
356	545
357	546
358	549
359	550
360	551
361	552
362	553
363	554
364	555
365	556
366	557
367	558
368	560
369	561
370	562
371	563
372	564
373	565
374	566
375	567
376	568
377	570
378	571
379	572
380	573
381	574
382	575
383	580
384	581
385	582
386	583
387	584
388	585
389	586
390	587
391	588
392	589
393	590
394	591
395	592
396	593
397	594
398	595
399	596
400	597
401	598
402	599
403	600
404	601
405	602
406	603
407	604
408	605
409	610
410	611
411	612
412	613
413	620
414	621
415	622
416	623
417	624
418	625
419	630
420	631
421	632
422	633
423	634
424	635
425	636
426	637
427	638
428	639
429	640
430	641
431	642
432	643
433	644
434	645
435	650
436	651
437	652
438	653
439	654
440	655
441	656
442	660
443	661
444	662
445	663
446	664
447	665
448	670
449	671
450	672
451	673
452	680
453	681
454	690
455	691
456	698
457	699
458	700
459	701
460	702
461	703
462	710
463	711
464	712
465	713
466	720
467	721
468	722
469	723
470	724
471	725
472	726
473	727
474	728
475	729
476	730
477	731
478	732
479	733
480	740
481	741
482	742
483	743
484	750
485	751
486	752
487	753
488	754
489	755
490	760
491	761
492	762
493	763
494	770
495	772
496	773
497	780
498	782
499	783
500	784
501	785
502	786
503	790
504	792
505	793
506	797
507	798
508	799
509	800
510	801
511	802
512	803
513	804
514	806
515	807
516	808
517	810
518	811
519	812
520	813
521	820
522	830
523	831
524	832
525	833
526	834
527	835
528	836
529	837
530	838
531	839
532	840
533	841
534	842
535	843
536	844
537	845
538	850
539	851
540	852
541	853
542	854
543	855
544	856
545	857
546	858
547	859
548	880
549	881
550	890
551	891
552	892
553	893
554	894
555	895
556	896
557	897
558	900
559	901
560	980
561	981
562	982
563	983
564	984
565	985
566	986
567	987
568	988
569	989
570	990
571	991
572	992
573	993
574	994
575	995
576	996
577	997
578	F00
579	F10
580	F11
581	F12
582	F13
583	F14
584	F15
585	F16
586	F19
587	F20
588	F21
589	F22
590	F23
591	F24
592	F25
593	F26
594	F29
595	F30
596	F31
597	F32
598	F33
599	F39
600	F40
601	F41
602	F42
603	F43
604	F44
605	F45
606	F46
607	F49
608	F50
609	F51
610	F52
611	F53
612	F54
613	F55
614	F56
615	F59
616	F60
617	F61
618	F62
619	F63
620	F64
621	F65
622	F66
623	F67
624	F69
625	F70
626	F71
627	F72
628	F73
629	M00
630	M10
631	M11
632	M12
633	M20
634	M21
635	M22
636	M23
637	M24
638	M25
639	M26
640	M27
641	M30
642	M31
643	M32
644	M33
645	M34
646	M35
647	M36
648	M37
649	M40
650	M41
651	M42
652	M43
653	M44
654	M45
655	M46
656	M47
657	M48
Sheet2

 

[GuusKoppes]

Rather than discussing the limitations of custom formats, wouldn't it be more interesting if you told us what it is you are trying to achieve? perhaps a totally different approach is possible.

Thank you for joining my thread! I tried to explain it at the start of the topic.
I would like to show text in a pivottable without using the option of adding the data to the data model. See an example of this below. The pivottable is part of a larger tool that has a lot of interaction with the user which asks for a lot of refreshing. The data model turned out to decrease performance to much.
I found out I could do it by applying custom number formats to the cells since I have the relation between the number in the pivot table row to the right and the description i want to show. But i can't add all the relations, only up to 206.
Does this make it more clear? Please let me know if there is anything else to make the problem more clear.