Excel numerical value in a cell

Hi Cherry, thanks for your query. There is no standard function in Excel to allow you to do this and to achieve it would involve some bespoke VBA. However, depending on what you want to achieve, have you thought about have 10 as the value in A3 and then drawing a white-filled rectangle over the cell with the number 8 in it, obscuring the real value but leaving it intact for use in formulae? The end result, visually at least, would be the same as your request.

Hope this helps,

Anthony