Though much requested there is no way to change a format in a calculated field, without moving it to a string.
but we can not take grand total for it ?????
The best way to get a grand total for it would be to find the grand total on a page of it's own and place the two sheets on a dashboard together.