Electrical Engineering With Excel - Formatting Frequency Numbers With SI Prefixes

Welcome to electrical engineering - with Excel. This is a series of videos, to help you make excel workbooks, for various electrical engineering problems, and circuit calculators. This video details the development of a custom number formatting code that will display frequency numbers (or any numbers) with their applicable SI prefix. Due to the constraints of Excel formatting, the frequency numbers outlined in this video are limited to Hz, kHz, and MHz. Basically, it enhances the readability of log frequency charts, which are omnipresent in electrical engineering. Format code for Hz, kHz, and MHz https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/2e949f5c6788c6afb0d09714527e3929f633f39f/Excel%20Custom%20Formatting%20Code%20for%20Frequencies 00:00 Introduction 00:33 Log-Log Plots 01:19 Frequency Axis Number as Scientific Notation 01:50 Introduction to the Custom Number Format 02:02 Excel Accounting Number Format Example 03:04 Format Frequency Numbers With SI Prefixes 04:54 Apply the Number Format 05:25 Formatting With SI Prefixes Only Without Hz Excel Electrical Engineering Excel Custom Number Formatting SI Prefixes