Auto Numbering using "&()&"

[Snowmanx812]

Hi, i like to write specifications in excel & wanted Auto Numbering as i often add new headings & to manually update all the numbers is to much effort.

I created a spreadsheet where if a "<" is added in column "B" and a heading in Column "C" then it would Auto Number in "D".

i am open to better ways of doing this, however when i get to 1.10, it shows it an 1.1, is there a way to overcome this?
I have attached a worksheet.

Example (2).xlsx
	A	B	C	D	E
4	1.00	<	OUTLINE PROJECT INFORMATION	1 OUTLINE PROJECT INFORMATION
5
6	1.01	<	Introduction	1.01 Introduction
7				The purpose of this Stage 2 report is to define the MEP concept designs relating to the project.
8
9				The details contained in this Stage 2 report will form the basis of the Stage 3 Design being produced by the chosen Design Contractor.
10
11
12	1.02	<	Client Description	1.02 Client Description
13
14				Our client operates state-of-the-art manufacturing facilities in three different continents and a globally integrated supply chain around the world.
15
16
17
18
19	1.03	<	Project Description	1.03 Project Description
20
21				The project is to convert a 1st floor storage section of a warehouse into a new office
22				The space was once used as a canteen, although it has all been stripped out, it has some water, waste & a DB.
23				This storage area has limited services & will generally require all new services.
24				There space is completely open with high ceilings & will require a new 600x600 ceiling grid to be installed.
25
26				There is a requirement to modify some existing external doors to create a new accessible entrance, these will require new power & motorised opening arms to the new doors.
27
28				There is also a requirement electrically to install new lights into the GF lobby/ landing area at the bottom of the stairs. If this can be shown as a Prov sum, then it can be firmed up later.
29
30
31	1.04	<	Phasing	1.04 Phasing
32
33				The works will be carried out in 1 phase.
34
35
36	1.05	<	As Fitted Drawings	1.05 As Fitted Drawings
37
38				No As Built Information is available
39
40
41	1.06	<	Project Considerations	1.06 Project Considerations
42
43				• Floor Void – It is a Mezzanine floor, no RAF is being installed
44				• Ceiling Height – not agreed, but circa 2.7m
45				• Ceiling Void – not agreed, but circa 2m void above new grid
46
47	1.07	<	ENVIRONMENTAL CONSIDERATIONS	1.07 ENVIRONMENTAL CONSIDERATIONS
48
49	1.08	<	EPC Rating	1.08 EPC Rating
50				There is an existing EPC & there is no requirement for the contractor to produce another EPC, however the contractor has a responsibility not to make it any worse or installing equipment that will lower the rating.
51
52
53	1.09	<	SKA	1.09 SKA
54				The Project has no SKA requirements
55
56
57	1.10	<	BREEAM	1.1 BREEAM	shows as 1.1 but should be 1.10
58				The Project has no BREEAM Requirements
59
60
61	1.11	<	WELL	1.11 WELL
62				The project has no WELL requirements
63
64
65	1.12	<	NABERS	1.12 NABERS
66				The project has no NABERS requirements
67
68
69	1.13	<	Soft Landings	1.13 Soft Landings
70				The project has no NABERS requirements
71
72
73	1.14	<	Seasonal Comissioning	1.14 Seasonal Comissioning
JB

Cell Formulas
Range	Formula
D4:D6,D73,D69,D65,D61,D57,D53,D49,D47,D41,D36,D31,D19,D12	D4	=""&(A4)&" "&(C4)&""
A5:A73	A5	=IF(B5="<",MAX($A$4:$A4)+0.01,"")

 

[Fluff]

How about

=TEXT(A6,"0.00 ")&C6

 

[Snowmanx812]

How about

=TEXT(A6,"0.00 ")&C6

thats perfect thanks

 

[Fluff]

You're welcome & thanks for the feedback.