View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Convert Grams to Pounds

ToolsAdd-inscheckmark the Analysis Toolpak.

If you look for the CONVERT function in help you would see these instructions.


Gord Dibben MS Excel MVP

On Thu, 11 Oct 2007 06:35:04 -0700, Stonepost
wrote:

When I use the formula =convert(10.5,"g","lbm") it always show the error NAME.
I have tried "trace error" and "evaluate formula" but aren't getting a
answer to how to change text to number etc. or whatever needs to be
corrected.

thanks,