Macro to remove dot (.) between numbers and the numbers to read 8 digits in a column still end of data with two zero at end
There are two types of data to convert in
Anyone can help
<tbody>
</tbody>
There are two types of data to convert in
Anyone can help
ht code | Expected results | ht code | Expected results | |
101.21 | 01012100 | 4016.93 | 40169300 | |
101.29 | 01012900 | 4016.94 | 40169400 | |
101.30 | 01013000 | 4016.95 | 40169500 | |
101.90 | 01019000 | |||
4016.99 | 40169900 | |||
4017.00 | 40170000 | |||
102.21 | 01022100 | 4017.00 | ||
102.29 | 01022900 | |||
4101.20 | 41012000 | |||
102.31 | 01023100 | 4101.50 | 41015000 | |
102.39 | 01023900 | 4101.90 | 41019000 | |
102.90 | 01029000 | |||
4102.10 | 41021000 | |||
4102.21 | 41022210 |
<tbody>
</tbody>
Last edited: