Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like this
=Num(sum(Sales),'###0')
and drag the column by mouse for enlarge it..
Hope it helps
Hi,
Thank you for your help. That's what i tried before but it didn't help.
Thxs,
Alec
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
Hi
Properties->Numbers->Select the fields to Money
Best regards,
TMF