Nice and useful code to make values in Excel sheets more readable! I am personally in favor of NOT skipping nano. I even asked Digikey support once why they avoided nano, but did not get a very satisfactory explanation as I recall. Your guess that it is old habits and a remnant from µ and µµ being the only options sounds plausible. Maybe there is a bit of a difference between Europe (more nano) and US (not so much nano) too, but I have no firm data on that. I rarely deal with capacitors in the mF range, but when I do I am guilty of skipping milli in favor of micro, so I realize I too am not consistent in using the best fit prefix...
Thanks for the comment. One reason why I did this was becuase in the future I plan to make Excel generate parts lists. The capacitor part numbers are huge, and I will probably use VBA with some string manipulation within the cells to generate part numbers.
Nice and useful code to make values in Excel sheets more readable!
I am personally in favor of NOT skipping nano. I even asked Digikey support once why they avoided nano, but did not get a very satisfactory explanation as I recall. Your guess that it is old habits and a remnant from µ and µµ being the only options sounds plausible. Maybe there is a bit of a difference between Europe (more nano) and US (not so much nano) too, but I have no firm data on that. I rarely deal with capacitors in the mF range, but when I do I am guilty of skipping milli in favor of micro, so I realize I too am not consistent in using the best fit prefix...
Thanks for the comment. One reason why I did this was becuase in the future I plan to make Excel generate parts lists. The capacitor part numbers are huge, and I will probably use VBA with some string manipulation within the cells to generate part numbers.