need decimal values in Excel

[#1]

Hi,

I got new requirement in my project, I have a pivot table in my dashboard i want to show the values without decimals in my pivot table.

But when i export or copy that object into excel i want display the decimals in excel.

Where can i change the setings,

can anyone know the solution about this.

regards,

baru

[#2]

I don't know of any easier way to do it, but you can use a macro to export it to Excel and set the format however you want.

[#3]

Hi Rebeccad,

Thanks for your reply,

Can you please tell me how to write the macro for this one.

regards,

baru

[#4]

See attached.  Make sure you set the following security settings for it to work:

On Opening (if applicable):

Under Edit Module:

[#5]

Oh hang on - I just noticed it is converting the integer.  I will adjust the macro and reload the test file for ya. One sec.

[#6 · Accepted solution]

Okay, here you go. Hope it helps!

[#7]

Thankyou rebeccad,

its working charm,

sorry to late for mark as correct answer.

regards,

baru

[Anonymous]

Hi Rebecca

In my QV I have dynamic decimal point like I can have option to select how many decimal point I need like

.0, .00, .000, .0000 etc.

In your example it's fixed value .0000

Anyway to keep open decimal option?

Thanks