Dear Reader & Writer
Hello;
How can I convert a several values at the same time using microsoft excel .
Because when I use function convert I have this problem! (as shown in the pictures).
Best regards
https://www.google.com/url?sa=t&source=web&rct=j&url=https://exceljet.net/excel-functions/excel-convert-function&ved=2ahUKEwiVzej4srfxAhWMhv0HHdd0CtYQFjACegQIBBAF&usg=AOvVaw3YLPobwexZh7VDMVFtQuP_
https://www.google.com/url?sa=t&source=web&rct=j&url=https://www.extendoffice.com/documents/excel/706-excel-unit-conversion.html&ved=2ahUKEwiVzej4srfxAhWMhv0HHdd0CtYQFjAOegQIJRAC&usg=AOvVaw3apHAPtq-qFdu-RTpFQj-D
https://www.google.com/url?sa=t&source=web&rct=j&url=https://corporatefinanceinstitute.com/resources/excel/functions/excel-convert-units-function/&ved=2ahUKEwiVzej4srfxAhWMhv0HHdd0CtYQFjAQegQIGhAC&usg=AOvVaw1Hjh1BOTHRgfqe_W5EbiD8
Hello;
As I know, the Convert function works with only one number (ore the reference) and can't use as array function.
The only solution what i found is to use table object and reference in excel.
(except the classic copy method)
Thank you very much your answers has very much helped ,me to get to the correct answer once again thank you.
- Badges
- Science topic