If you just want the number to "look like" 4.565 you can custom format as
Luke points out.

If you want it to actually be 4.565 then you must divide it by 1000 manually
or using VBA event code or set your Fixed Decimals to 3 so 4565 is actually
entered as 4.565

Note: setting FD to 3 is a sheet function and will affect all numbers
entered in any cell.


Gord Dibben MS Excel MVP

On Wed, 29 Apr 2009 10:14:01 -0700, Atiq
wrote:

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!