Straight table, remove decimal

[everest226]

HI  i have a amount in dollar and cents . how to remove cents value and also $ sign.

for eg  $316.25     i only want 316

[sunny_talwar · Accepted solution]

Go to the number's tab and change the format from $#,##0.00 to $#,##0

or if you are using a num function for the format, then change the format there