NOte that is still contains the value of 4565, even if it displays something
looking like something else. If you need the real value to really be divided
by 1000 then set "fixed decimals" to 3 in menu tools-options or Excel
options (version dependent where it is).

HTH. Best wishes Harald


"Atiq" wrote in message
...
How do I format a number cell so when I enter any value in it, it shows
the
input value dvided by 1000? For instance if I enter 4565 the cell should
show
4.565. Thanks in advance for help!