Try format-cells-custom
then in the Type box enter the following:
0.00" M³"
Note that you enter the superscript 3 as Alt 0179 and you must use the
numeric keys of the keypad.
(On a laptop, this may be the only time you ever use the NumLk key)

christobal < wrote:
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/