View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
JWolf JWolf is offline
external usenet poster
 
Posts: 136
Default Special string formatting

In VBA:
ActiveCell.NumberFormat = "0.00 ""M³"""
Again, you must use the numeric key pad and Alt0179 while in the VBA
code editor.

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/