Forum Discussion
Cell Types and Cell formats
Hi For my work we use a spreadsheet with a colour coding system for our clients, we have a column for dates, which the cell format is dates, however when changing for example from yellow to green th...
As you can see in the first screenshot the cell type is the yellow invited, in the second it is green and renewed, however the cell format changes to accounting. I want all other cells to be accounting format but the date one to stay as date.
Thanks
FinAndo12 The screen-shot didn't make it into your post?
FinAndo12 The styles include the number format. Here is how to remove the number format from those styles:
- Right-click the Style in question and select "Modify...":
- In the next box, uncheck "Number":
- Repeat for the other styles
For more about cell styles, you could read this article: https://jkp-ads.com/articles/styles.asp
Note that for the rows which currently have wrong number formats you still have to update them back to what you want them to be.
- Right-click the Style in question and select "Modify...":