christobal wrote in message ...
Am using a excel report generator which works with excel template file.
Have a cell in the template file which is referred to as Grid_Value.
This cell is populated with a string representing cubic meters of
water i.e
203.34M3
How can the field be formatted in vba to show 203.34 M (superscript)3


---
Message posted from http://www.ExcelForum.com/

The ³ of M³ is actually available as a character in its own right
(Check Character map or copy from this message) - therefore suggest
one solution is to define ...
..
Const Mcub As String = " M³"
..
Locate the cell containing your string and then ...
..
ActiveCell.Value = Left(ActiveCell.Value,Len(Activecell.Value)-2) &
Mcub
..
Regards ...