Regarding ODS tagsets

[JasonNC]

Hi All,

Dollar value original

$24,995,882.24

$3,795,926.11

$2,960,272.50

$2,340,307.13

Dollar value in 000 format

$24,995

$3,795

$2,960

$2,340

I create the report using ods tagsets.excelxp  and proc report

Is it possible to show in 000 format but when I click on the cell i can see the full value ?

Currently the report produces the value in 000 format but as in excel I wanto print it in 000 format but when the user clicks on cell he needs to be able to view the full decimal value

[Reeza]

How are you applying the format? 

A tagattr format should work, assuming there's an Excel format that allows for the format you want. 

[JasonNC]

I am applying the format using Tagattr

proc format library=delfmt.Delq;
picture dollrfmt
low - < 0 = '0000,009)' (mult=.001 prefix='($')
0 = '-'
0 < - high = '000,009' (mult=.001 prefix='$');
run;

define Dolrs / order order=data " $ Dollars * (000)"  format=dollrfmt. style={tagattr='format:$###,###'};

what I am trying to achieve progrmatically is 

$ Dollars  (000)

$24,995

$3,795

$2,960

$2,340

When i click on the above display it should display the below value in cell

24995.88224