The CONVERT function is part of the Analysis ToolPak Add-In. You'll need to
activate that first.

TOOLS
ADD-INS
Check "Analysis ToolPak"
OK

HTH,
Elkar


"April" wrote:

Hi

I am trying to convert a cell from metre to ft. The formula I use is
=convert(C1,"m","ft"). This results in #NAME? If I put a number in place
of C1, the formula still does not work.

I'd appreciate it if someone could let me with why this is happening.

Thank you in advance