| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DataTable number format
Hi,
I have a chart that I populate from arrays thru VBA code. The DataTable for the chart shows the values as they are entered in the array. Is there a way to have the values in the DataTable shows in the format "0.00%"?? please help! I tried to use the FormatPercent function, the NumberFormat function, Format function..etc. with no success. Any help will be greatly appreciated. Thanks, MB |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DataTable number format
This didnt work (after selecting the cells):
Selection.NumberFormat = "0.00%" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DataTable number format
I am not reading from cells but reading from arrays!
"Chip" wrote: This didnt work (after selecting the cells): Selection.NumberFormat = "0.00%" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart's DataTable | Charts and Charting in Excel | |||
| Needing to re-order a datatable display on an Excel chart | Charts and Charting in Excel | |||
| Can anyone align the numbers within the datatable of a chart? | Charts and Charting in Excel | |||
| Format numbers in chart datatable | Charts and Charting in Excel | |||
| Number format based on number format of another cell in another workbook | Excel Programming | |||
Linear Mode
