Hi,

Either
#,,
or
0,,

will work. You might also consider

#,,"M" or 0,,"M"
or
#,,KK or 0,,KK

If this helps, please click the Yes button

Cheers,
Shane Devenshire
"Kevin" wrote:

Hi

Is there a way I can format a number so that a value of 1,000,000 shows 1

thanks
--
Kevin