Tbale chart format issue

[alec1982]

hi Guys,

I have a table chart where the nrs on it are showing like:

Total Sales ######

Total Trans ######

Profit  $154,785

the nrs that showing in ###### are large nrs like 62,514,478

Anybody knows how to fix that?

Thxs for your help.

Badr

[MayilVahanan]

Hi

Try like this

=Num(sum(Sales),'###0')

and drag the column by mouse for enlarge it..

Hope it helps

[alec1982]

Hi,

Thank you for your help. That's what i tried before but it didn't help.

Thxs,

Alec

[MayilVahanan]

Hi

Can you post a sample file?

or try in number tab-> integer ,in format pattern gives number of # as per your requirement to display the number

[#5]

Hi

Properties->Numbers->Select the fields to Money

Best regards,

TMF