Using Copilot in Excel to show additional units of measure

1. Enable Copilot unit conversions 
Select the cell containing the value in Excel 
Click the "Data Analysis" button in the Copilot sidebar 
Enter the prompt word: "Add [target unit] conversions" 
Common unit formula templates 
excel 
=CONVERT(A2, "kg", "lb") // kilograms to pounds 
=A2*24 & " hours" // days to hours 
2. Useful tips 
Create custom units panel 
Insert → Table → Design units comparison table 
Use XLOOKUP to auto-match: 
excel 
=XLOOKUP(B2,Units Table[Original Units],Units Table[Target Units])*A2 
3. Quickly generate conversion columns 
Right click on the data columns → Copilot suggests 
Select "Generate Derivative Columns" → Enter unit requirements 
Advanced implementations Program 
Dynamic unit selector 
excel 
=LET( 
 value, A2, 
 unit, DROPDOWN({"kg", "lb", "g"},1), 
 IF(unit="kg", value*2.20462, IF(unit="lb", value/2.20462, value*1000)) 
) 
4. Cross-unit automatic recognition 
excel 
=IF(ISNUMBER(SEARCH("kg",B2)), A2*1000, IF(ISNUMBER(SEARCH("lb",B2)), A2*453.592, A2))