How to make a cell as odd or even number

[zjianguk]

Hi, for my interest. I'd like to know how to make a cell C1 as any odd number. Then next time, when the file is opened again, cell C1 is made as any even number.

Is there a clever way to do this without VBA?

[Pete_UK]

I don't think you believe me, do you?

Pete

[zjianguk]

There must be a way to deal with this.

[mehmetcik]

Nope.

Without a macro its impossible.

but it can be a simple macro.



somewhere put in a formula =c1+1
start the macro recorder. [ Developer, start recorder ]

copy the cell with your formula and then paste special value into c1

stop the recorder.

Hey Presto.

For super **** functionality. call the macro auto_open or auto_close and it will run when you open or close the spreadsheet.