Excel 2000 onward...
Content of B1 Cell : 17/12/2010
Content of A4 Cell : 7
Formula of C5 cell : =B1+A4
Gives error at C5 Cell #VALUE!
Solution:
With WinXp Change setting Date to dd/MM/yyyy ( Control Panel- Regional and Langauge Options - Customized - Date - Short Date )
After resolving problem content of C5 : 24/12/2010
Subscribe to:
Post Comments (Atom)
1 comment:
Valuable post, thank you for this informative info. Keep sharing
Web Hosting India |
Domain Name Registration India
Shared hosting packages
Post a Comment