Specific Row format from price to number


I have Column X with ‘price’ format, but there is 1 specific row in which I have a number that I want to express as a Number (without $ symbol) and not as a price. Is there a way to format this specific row?

Also, I have about 50+ columns, all with price format, they all by default were set up to have 2 decimals, I want 0 decimals but I don’t want to change the format column by column since they are 50+, is there a way to set up 0 decimals for all columns at once?

Thank you


Not really. There is some “black magic” with json data embedded in a gsheet comment on the header cell for each column to define all of its properties, but I’ve never been able to reliably figure it out.

1 Like