Forum Discussion
Alphanumeric Data
- I hope you don't misunderstand. It is good that you are here and of course you are welcome, as we are at microsoft in this forum.
I was concerned that the definition could be precise. As you described it at the beginning it was to be understood as if you needed a solution to your problem. But you would like to propose a solution / disseminate it. This could be better pointed out. Anyway, I would like to apologize from the start if I have worded anything wrong and accidentally offended you.
To put it briefly, please ask when and how much you want, there are no stupid questions, in the worst case you will get bad answers (some of them unintentionally from me).
Through questions I also learned what I know (or not) today.
I hope you continue to have fun with Excel .... the most beautiful invention since Schoko ... Uh, Microsoft.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
This works on a range of data. What I want is a toggle button in Excel configuration that turns off the standard Excel functionality of removing leading zeros from alphanumeric, imported data.
Using any programming method may spoil your data in another data range /Sheets,, and if you want to apply LEADING ZEROs as soon you open the Workbook,, in that case you need Workbook Open Event,, but remember then after you find Leading Zeros everywhere with all numeric Value !!
- I do not need this for ranges already in Excel. I need it for importing data INTO Excel.
Consider example source data:
Segment 1 Segment2 Segment3 Amount
0000 0001 0002 10.00
0001 0100 0025 25.00
1000 0005 2500 10.00
3000 0000 0050 5.00I want to import this data with the leading zero's in the segment columns intact.
Right now I have to use power query to import; then back out the automatic formatting step.
I have to go into "Transform Data" and back out the "Changed Type" step.
^^ Now I have the correct data.
What I want is a toggle switch in Excel that disables the automatic trimming of leading zero's from imported data.
I hope this makes sense.
Thanks, Paul Spanbauer
- Could you please write ,, how you are IMPORTING data ,,, any third party tool or from DATA tab ,,, Get External Data,,,,, and let me say,,, after importing the data with leading zeros can't you use the VBA code I've suggested,,, don't you think is a quite useful one !!