what is the reason type 1 or some number and enter then display divided by 100
L Lahi Sep 17, 2008 #1 what is the reason type 1 or some number and enter then display divided by 100
J Jan Karel Pieterse Sep 17, 2008 #2 Hi Lahi, what is the reason type 1 or some number and enter then display divided by 100 Click to expand... Tools, options, Edit tab, remove check from box "Fixed decimal places". Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com
Hi Lahi, what is the reason type 1 or some number and enter then display divided by 100 Click to expand... Tools, options, Edit tab, remove check from box "Fixed decimal places". Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com
