close
In the excel spread sheet.
when ever I enter any number it gets divided by 1000 on its own.
say if i enter 1 excel convert it to 0.001
i tried format cell option but could not correct it,
does any one know WHY?
Try this:
Toolsgt;Optionsgt;Edit tab
Uncheck: Fixed Decimal Places.
(it's probably set for 3)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Proquot;Jagquot; wrote:
gt; In the excel spread sheet.
gt; when ever I enter any number it gets divided by 1000 on its own.
gt; say if i enter 1 excel convert it to 0.001
gt; i tried format cell option but could not correct it,
gt; does any one know WHY?
全站熱搜
留言列表
