Square or Cube root (help)

[ranthrave]

Good day sir/maam!

How to put a square/cube root in cell A1? Do I need a VBA on this?
Can't find it in excel 2007. Kindly help me ctrl+shift++ doesn't work.

thank you very much

 

[Juan Pablo González]

=a1^(1/2)

=a1^(1/3)

 

[ranthrave]

=a1^(1/2)

=a1^(1/3)

Not that thing sir.

What i want is someting like square meter m2. Putting 2 in uppercase. XD

 

[Marcelo Branco]

Hi,

Maybe this can help
http://www.ozgrid.com/forum/showthread.php?t=105054&page=1

M.

 

[ranthrave]

Finally found it.

 

[Marcelo Branco]

Finally found it.

Just for curiosity: did you use the link i suggested?

M.

 

[ranthrave]

Just for curiosity: did you use the link i suggested?

M.

Nope sir...

I use the subscript to do that.. Anyway thank you for your reply

 

[Marcelo Branco]

Oh, i thought you wanted superscript or something like

<TABLE style="WIDTH: 50pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=66><COLGROUP><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 50pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=66 align=right>32,00 m²</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>100,00 m³</TD></TR></TBODY></TABLE>

If you solved it by yourself, it's OK!

M.