View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default using the 'Convert' function

I definitely spoke too soon and without knowledge when I stated "convert
function cannot do this"


Gord

On Tue, 24 Nov 2009 10:14:07 -0800, Teethless mama
wrote:

=CONVERT(CONVERT(CONVERT(1,"m","ft"),"m","ft"),"m ","ft")



"M-A H" wrote:

Wish to convert CBM [Cubic Meter] to FT3 [Cubic Feet] andy suggestions on
what the formula should be..?
TY