Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-20-2021, 03:43 AM
xp user xp user is offline convert command query Windows 10 convert command query Office 97-2003
Novice
convert command query
 
Join Date: Nov 2020
Posts: 6
xp user is on a distinguished road
Default convert command query


old pc running windows 10 home with ms office XP, (pc not attached to wifi, just used as a word processor), I have 2 columns on a spreadsheet, one lbs, the other kgs,
when I put the weight in column E in lbs, I want column H to automatically convert to kgs, I am using =convert(E3,"lbm","kg") in cell H3, I am getting the error message #NAME?, can anybody please advise me on where I am going wrong, all help and advice appreciated
Reply With Quote
  #2  
Old 04-20-2021, 05:39 AM
NoSparks NoSparks is offline convert command query Windows 10 convert command query Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 814
NoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the rough
Default

According to this page
The CONVERT function is new to Excel 2007, so is not available in earlier versions of Excel.
Reply With Quote
  #3  
Old 04-20-2021, 07:04 AM
xp user xp user is offline convert command query Windows 10 convert command query Office 97-2003
Novice
convert command query
 
Join Date: Nov 2020
Posts: 6
xp user is on a distinguished road
Default

thank you NoSparks, for your prompt reply, I appreciate your help and advice
Reply With Quote
  #4  
Old 04-25-2021, 09:49 PM
trevorc trevorc is offline convert command query Windows 7 32bit convert command query Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 165
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

1kg = 2.20462262 lbs

Make your own formula
Reply With Quote
  #5  
Old 04-26-2021, 12:29 AM
xp user xp user is offline convert command query Windows 10 convert command query Office 97-2003
Novice
convert command query
 
Join Date: Nov 2020
Posts: 6
xp user is on a distinguished road
Default

thank you trevorc, much appreciated
Reply With Quote
  #6  
Old 04-26-2021, 12:30 AM
xp user xp user is offline convert command query Windows 10 convert command query Office 97-2003
Novice
convert command query
 
Join Date: Nov 2020
Posts: 6
xp user is on a distinguished road
Default

thank you trevorc, your help and advice is appreciated
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command button. To multi command Taylormations Word VBA 11 09-14-2020 02:39 AM
Show table list by using chek box command and save document on sharepoint by using command button Zhibek Word VBA 3 08-16-2018 06:19 PM
Query and Power Query not working Excel 2016 bl10 Excel 0 07-22-2016 06:25 PM
command button query smalc Word VBA 2 03-16-2015 08:26 PM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? mag Excel 0 10-18-2012 11:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft