How to format to make say 25000 input to show 25

[bigyuen]

I would like to achieve a result is - to input a figure, it will automatic divide by 1000, say input 25000, it will display 25 in the cell.

Thanks

 

[Seti]

Welcome to the board.

If you want to retain 25,000 in the cell but display only 25, then a custom format of #,##0, should do it. Note the trailing 0, this essentially divides the displayed number by 1,000. If you wanted to display 25 million as 25, you'd use 2 trailing commas.

If you want to actually change the underlying value from 25,000 to just 25, you would need to use a worksheet change event in VBA.

 

[bigyuen]

It works.

Thank a lot