alwayssunny
New Member
- Joined
- Dec 14, 2019
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
Hey everyone, first off Happy Easter to those that celebrate it and great to see that this is the same helpful program. I am having a bit of an issue that I have spent over and hour trying to solve. First off the attached spreadsheet has an issue with zeros so any cell with less than 4 numbers means that zeros are missing. I went to format cells and then custom and entered 4 zeros it solved the issue only temporarily because as soon as I try to split the numbers into individual columns using Text to Columns it reverts.
When I use Text to Columns nothing simply happens. I have used the Xl2bb add-in to make it easier to explain my issues. Thanks for reading and looking forward to your help.
When I use Text to Columns nothing simply happens. I have used the Xl2bb add-in to make it easier to explain my issues. Thanks for reading and looking forward to your help.
Register Tally.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Detroit Midlands | ||||
2 | Date | Time | Items | ||
3 | 3/26/2021 | 04:55 PM | 984 | ||
4 | 3/26/2021 | 02:55 PM | 5,408 | ||
5 | 3/26/2021 | 12:55 PM | 1,204 | ||
6 | 3/26/2021 | 10:25 AM | 7,951 | ||
7 | 3/26/2021 | 08:25 AM | 4,945 | ||
8 | 3/25/2021 | 08:20 PM | 827 | ||
9 | 3/25/2021 | 04:55 PM | 7,471 | ||
10 | 3/25/2021 | 02:55 PM | 7,885 | ||
11 | 3/25/2021 | 12:55 PM | 8,634 | ||
12 | 3/25/2021 | 10:25 AM | 8,820 | ||
13 | 3/25/2021 | 08:25 AM | 8,640 | ||
14 | 3/24/2021 | 08:20 PM | 948 | ||
15 | 3/24/2021 | 04:55 PM | 8,787 | ||
16 | 3/24/2021 | 02:55 PM | 9,743 | ||
17 | 3/24/2021 | 12:55 PM | 3,674 | ||
18 | 3/24/2021 | 10:25 AM | 1,634 | ||
19 | 3/24/2021 | 08:25 AM | 6,705 | ||
20 | 3/23/2021 | 08:20 PM | 1,027 | ||
21 | 3/23/2021 | 04:55 PM | 6,392 | ||
22 | 3/23/2021 | 02:55 PM | 9,200 | ||
23 | 3/23/2021 | 12:55 PM | 3,126 | ||
24 | 3/23/2021 | 10:25 AM | 2,528 | ||
25 | 3/23/2021 | 08:25 AM | 7,969 | ||
26 | 3/22/2021 | 08:20 PM | 1,579 | ||
27 | 3/22/2021 | 04:55 PM | 2,222 | ||
28 | 3/22/2021 | 02:55 PM | 464 | ||
29 | 3/22/2021 | 12:55 PM | 2,691 | ||
30 | 3/22/2021 | 10:25 AM | 2,509 | ||
31 | 3/22/2021 | 08:25 AM | 5,107 | ||
32 | 3/21/2021 | 08:20 PM | 9,135 | ||
33 | 3/21/2021 | 04:55 PM | 845 | ||
34 | 3/21/2021 | 02:55 PM | 3,895 | ||
35 | 3/21/2021 | 12:55 PM | 3,691 | ||
36 | 3/21/2021 | 10:25 AM | 4,349 | ||
37 | 3/21/2021 | 08:25 AM | 6,585 | ||
38 | 3/20/2021 | 08:20 PM | 2,586 | ||
39 | 3/20/2021 | 04:55 PM | 8,399 | ||
40 | 3/20/2021 | 02:55 PM | 2,307 | ||
41 | 3/20/2021 | 12:55 PM | 5,756 | ||
42 | 3/20/2021 | 10:25 AM | 2,010 | ||
43 | 3/20/2021 | 08:25 AM | 1,495 | ||
44 | 3/19/2021 | 08:20 PM | 6,984 | ||
45 | 3/19/2021 | 04:55 PM | 394 | ||
46 | 3/19/2021 | 02:55 PM | 4,169 | ||
47 | 3/19/2021 | 12:55 PM | 5,234 | ||
48 | 3/19/2021 | 10:25 AM | 1,077 | ||
49 | 3/19/2021 | 08:25 AM | 3,251 | ||
50 | 3/18/2021 | 08:20 PM | 8,113 | ||
51 | 3/18/2021 | 04:55 PM | 462 | ||
52 | 3/18/2021 | 02:55 PM | 9,776 | ||
53 | 3/18/2021 | 12:55 PM | 790 | ||
54 | 3/18/2021 | 10:25 AM | 9,731 | ||
55 | 3/18/2021 | 08:25 AM | 5,084 | ||
56 | 3/17/2021 | 08:20 PM | 3,728 | ||
57 | 3/17/2021 | 04:55 PM | 3,254 | ||
58 | 3/17/2021 | 02:55 PM | 13 | ||
59 | 3/17/2021 | 12:55 PM | 4,228 | ||
60 | 3/17/2021 | 10:25 AM | 4,764 | ||
61 | 3/17/2021 | 08:25 AM | 7,211 | ||
62 | 3/16/2021 | 08:20 PM | 1,626 | ||
63 | 3/16/2021 | 04:55 PM | 8,194 | ||
64 | 3/16/2021 | 02:55 PM | 7,044 | ||
65 | 3/16/2021 | 12:55 PM | 8,072 | ||
66 | 3/16/2021 | 10:25 AM | 1,584 | ||
67 | 3/16/2021 | 08:25 AM | 6,055 | ||
68 | 3/15/2021 | 08:20 PM | 4,117 | ||
69 | 3/15/2021 | 04:55 PM | 2,484 | ||
70 | 3/15/2021 | 02:55 PM | 9,456 | ||
71 | 3/15/2021 | 12:55 PM | 7,698 | ||
72 | 3/15/2021 | 10:25 AM | 9,181 | ||
73 | 3/15/2021 | 08:25 AM | 7,545 | ||
74 | 3/14/2021 | 08:20 PM | 843 | ||
75 | 3/14/2021 | 04:55 PM | 9,913 | ||
76 | 3/14/2021 | 02:55 PM | 5,256 | ||
77 | 3/14/2021 | 12:55 PM | 311 | ||
78 | 3/14/2021 | 10:25 AM | 818 | ||
79 | 3/14/2021 | 08:25 AM | 7,447 | ||
80 | 3/13/2021 | 08:20 PM | 8,295 | ||
81 | 3/13/2021 | 04:55 PM | 1,751 | ||
82 | 3/13/2021 | 02:55 PM | 9,956 | ||
83 | 3/13/2021 | 12:55 PM | 8,051 | ||
84 | 3/13/2021 | 10:25 AM | 2,660 | ||
85 | 3/13/2021 | 08:25 AM | 9,923 | ||
86 | 3/12/2021 | 08:20 PM | 3,766 | ||
87 | 3/12/2021 | 04:55 PM | 5,656 | ||
88 | 3/12/2021 | 02:55 PM | 3,182 | ||
89 | 3/12/2021 | 12:55 PM | 686 | ||
90 | 3/12/2021 | 10:25 AM | 7,740 | ||
91 | 3/12/2021 | 08:25 AM | 2,351 | ||
92 | 3/11/2021 | 08:20 PM | 9,632 | ||
93 | 3/11/2021 | 04:55 PM | 15 | ||
94 | 3/11/2021 | 02:55 PM | 2,783 | ||
95 | 3/11/2021 | 12:55 PM | 2,907 | ||
96 | 3/11/2021 | 10:25 AM | 3,603 | ||
97 | 3/11/2021 | 08:25 AM | 5,969 | ||
98 | 3/10/2021 | 08:20 PM | 7,920 | ||
99 | 3/10/2021 | 04:55 PM | 9,929 | ||
100 | 3/10/2021 | 02:55 PM | 5,997 | ||
101 | 3/10/2021 | 12:55 PM | 4,889 | ||
102 | 3/10/2021 | 10:25 AM | 1,246 | ||
Sheet1 |