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...
How exactly do you "change the cell type"? Can you post a screen-shot of before and after?
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?