How to Add Units to Excel Cell

*How to Add Units to Excel Cell*

Microsoft Excel is a powerful spreadsheet program widely used for data analysis, calculations, and record-keeping. Adding units to your Excel cells is a valuable practice to ensure clarity and prevent misunderstandings in your data. Whether you're working with measurements, financial figures, or any other numeric data, including units enhances the readability and comprehensibility of your spreadsheet.

In this intermediate excel tutorial I’ll show you an excellent excel trick that will allow you to specify units i.e. kg, feet, inches, mile, km. Usually if you add text with your cell value it converts the value as text resulting error in formulas. But in our solution you’ll be able to add units and also you can use those cells inside your formulas.

Follow the procedure below to add units with cell value in Microsoft excel.
*Step 1:* Highlight a column or range you want to add units.
*Step 2:* Right-click to select “Format Cells…”.
*Step 3:* In the “Format Cells” dialog box, switch to the “Custom” tab.
*Step 4:* Type 0 “Your unit name” into the “Type” field.
*Step 5:* Click “OK.”

#CellFormatting #Excel #Unit

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[ganapathi]

How to use xlookup basic to complex video upload please (for multiple to single criteria) for matching data from two different sheets with duplicate values

[ganapathi]

If duplicate value found in lookup value vlookup takes 1st data as solution remaining as N/A, so how can i solve this one, is there any other function there? I want second data need to be shown instead of N/A ....