ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Date:01/10/2021Date Example: dd/mm/yyyyInstructions
2
1. Paste the data you would like to have formated below the yellow line
3
2. Enter a Date in Cell B1, this date will show on each of the newly formated records
4
3. Click the "Format" Button
5
6
7
8
Account Balance
Balance (Incl. Interest)
9
BKA029-3439.69-3508.48
10
BRA010-434.6404-443.33
11
BPA011-6961.77-7101.01
12
BPA016-1135.86-1158.58
13
BPT012-673.53-687
14
BLA009-428.16-436.72
15
BLA013-3387.68-3455.43
16
BVA006-14422.7916-14711.25
17
BVA009-3518.8452-3589.22
18
BVA039-5238.5905-5343.36
19
BMA001-2579.66-2631.25
20
BMA018-3647.78-3720.74
21
BMA038-500.01-510.01
22
BMA043-5002.82-5102.88
23
BMA064-949.44-968.43
24
BMA070-1846.67-1883.6
25
BMA074-3216.45-3280.78
26
BMA076-5182.85-5286.51
27
BMA086-6064.18-6185.46
28
BTA017-1943.31-1982.18
29
BTA072-545.49-556.4
30
BTA104-3654.27-3727.36
31
BTA140-1795.93-1831.85
32
BTA164-745.09-759.99
33
BTA327-2422.37-2470.82
34
BTA335-3336.92-3403.66
35
BTA354-1235.11-1259.81
36
BTA461-2094.63-2136.52
37
BTA467-4073.87-4155.35
38
BTA526-3472.35-3541.8
39
BTA530-900-918
40
CDA003-2571.49-2622.92
41
CDA010-3248.51-3313.48
42
CBA1707-1672.76-1706.22
43
CBA1710-3978.88-4058.46
44
CBA1713-290.13-295.93
45
CBA1717-281.56-287.19
46
CBA1718-3554.36-3625.45
47
CBA1725-2085.6-2127.31
48
CBA1731-993.56-1013.43
49
CBA1736-5539.65-5650.44
50
CGA003-7880.47-8038.08
51
CNA001-4165.95-4249.27
52
CNA011-3705.92-3780.04
53
CNA015-957.81-976.97
54
CNA021-2106.52-2148.65
55
CNA022-1835.04-1871.74
56
CNA038-5025.57-5126.08
57
CNA047-6119.28-6241.67
58
CCA003-697.51-711.46
59
CCA011-1966.95-2006.29
60
DHA031-6367.81-6495.17
61
DDA010-498.2-508.16
62
DDA011-11407.92-11636.08
63
DDA018-350.09-357.09
64
EGA010-4066.7699-4148.11
65
EGA011-1817.2-1853.54
66
EGA024-2854.3099-2911.4
67
EGT012-1143.0201-1165.88
68
FHA004-860.31-877.52
69
FHA020-488.86-498.64
70
FHA039-1826.48-1863.01
71
FHA051-338.3-345.07
72
GEA001-3396.94-3464.88
73
GEA002-3992.43-4072.28
74
GEA003-3424.43-3492.92
75
GLA047-728.67-743.24
76
GLA255-4403.34-4491.41
77
IVA018-13791.41-14067.24
78
IVA032-462.41-471.66
79
KSA001-203.8-207.88
80
KSA006-3907.72-3985.87
81
KSA010-435.53-444.24
82
KSA018-2949.88-3008.88
83
MLA010-2879.2-2936.78
84
MLA011-391.43-399.26
85
NPA006-1932.71-1971.36
86
OVA017-238.3531-243.12
87
OVT024-607.28-619.43
88
RHA002-2173.0804-2216.54
89
RBA014-7265.2798-7410.59
90
RBA027-6418.0095-6546.37
91
RBA039-9706.5902-9900.72
92
RBA050-8257.6198-8422.77
93
RBA114-5105.2301-5207.33
94
RBA116-1245.88-1270.8
95
RBA130-4040.59-4121.4
96
RBA137-3660.6198-3733.83
97
RBA151-8875.2301-9052.73
98
RGA002-2257.47-2302.62
99
SMA003-2000-2040
100
SMA008-500-510