Number format

[yogitamehta10]

  HI ALL,

I have in my dashboard all the values are coming in712239181.798289  bot users want to show in  dashboard in thousand like this  712,239 and when we export the data it should  come original value in712239181.798289   ,..Please help. I’m using this number format  .’ #,##0 ‘.

TIA!

[antoniotiman]

Try this

Num(KeepChar(Field,'0123456789.')/1000,'#,##0 K')

K is optional

[el_aprendiz111]

Hi,

[yogitamehta10]

But I cant  export in the original  format then

[yogitamehta10]

Any other help ? swuehl‌ tresesco‌

[el_aprendiz111]

Hi Yogita

with a macro

sub sendXls
SET CHART = ActiveDocument.GetSheetObject("CH11")
SET X = Chart.GetProperties
Chart.SendToExcel
SET CHART=NOTHING
SET X = NOTHING
end sub