Forum Discussion
Solved
Alphanumeric Data
Hi Team Excel I would like to see added a toggle switch to turn on or off stripping leading zero's from numeric text data when opened or imported into Excel. Excel automatically strips leading z...
- 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)
There was something ... believe in cell formatting
Custom formatting
0; -0 ;; @ that was for the zeros in front of it
0. ### that was, I think, for after the decimal point
Try it
I tried the first "0; -0 ;; @" formula and works very well with zeros before the comma.
Hope you can be helped with it.
Niklino
Custom formatting
0; -0 ;; @ that was for the zeros in front of it
0. ### that was, I think, for after the decimal point
Try it
I tried the first "0; -0 ;; @" formula and works very well with zeros before the comma.
Hope you can be helped with it.
Niklino