Format cell, Custom format (on the number tab)

#"."###

OR

0"."###

if you always want a number in front of the decimal.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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!