Excel Formulae : How to convert text to date in Excel 2010 (fomat dd/MM/yyyy)

How to  convert a text data cell to date cell in Excel 2010

For Example the format of text file is given below ..... 23/04/2012 12:00:00 AM

17/08/2012 12:00:00 AM

20/10/2012 12:00:00 AM

22/10/2012 12:00:00 AM

29/12/2012 12:00:00 AM

Me Nexus?

For this we have to convert the text to serial number.

the date value function returns the text date to serial number ( calculated as on jan 01 1990)

mid function is use to substring the text

apply the below formula

=DATEVALUE(CONCATENATE(MID(B1,7,4),"/",MID(B1,4,2),"/",MID(B1,1,2)))

after that format the cell as date



Hi Friends,

       Here you can find some Microsoft excel formula that could apply to your excel sheets. Please reply once you tried it out. mail me at  :: belazy1987atgmaildotcom

If you are unable to copy images or any resources from ms document file(.doc/.docx) format try this : java-lazy blog

+joseph james 
+Vipin Cp


Thanks +deepajayaprakash payyanakkal  for her support

Similar posts

1. Taking reports using pivot table in ms office excel
2. How to share an microsoft office excel to work multiple user simultaneously
3. consolidate many table to one using consolidate option in ms office excel
4. Working with pivot table in microsoft office excel 2010
5. working with share point in microsoft office
6. create a internal chat application in organization

http://belazy.blog.com/

Software keys

AVG 8

key

VDCST-JDNDZ-BABPA-S8EBG-P7KK4-ZMNX

DREAMWEAVER MX

Sl No: WPD700-58202-88194-29915

4C85-200E-4005-0004-0000-3M00-0800-35X3-0000-404C-EXCC-1451  nero:7

Windows xp

Q7Q6W Q3846 RGDBM 6R883 3736G

YFKBB G996G VWGXY 2V3X8

Q7Q6W Q3846 RGDBM 6R883 3736G

Windows Vista

Ffp3t htkf2 4xymp kf8x9 mghkt

Photoshop CS

serial key
1131-1028-1537-2956-7072-0359

Microsoft Office

KGFVY-7733B-8WCK9-KTG64-BC7D8

Microsoft Office 2007 Product key

FOR OFFICE STANDARD 2007

CTKXX-M97FT-89PW2-DHKD3-74MYJ
KCBJJ-67B9Q-KQXF2-VQV2V-6TXJ3
4NJ39-D83K0-2HNS0-39OKD-4ZHJ8

FOR OFFICE HOME and STUDENT 2007

PHXQ7-GMKQ3-XPYRB-YXTVM-XXT73
B4MKP-KP9YP-7TBQ4-7T4XF-MTGWY
DDY79-433JV-2RXGX-MQFQP-PFDH8
KGFVY-7733B-8WCK9-KTG64-BC7D8
DDY79-433JV-2RXGX-MQFQP-PFDH8
WRGJQ-2J2HB-8XP8D-6J2YK-BMFFD
HX2HC-MJM6Q-4487F-23FMP-9VKV8
HX2DJ-36TJX-CRVRJ-C72Q8-CJTBQ
V82W3-BM72R-XRHWG-CP69F-4FPMT
VHGFG-FVMY3-HHP46-RXVDJ-8R6BY
TC2QP-QBCP7-WQ62V-WBF92-WWG73
WQ27D-PY77P-R9CQK-MCPPB-QGJYQ

FOR OFFICE PROFESSIONAL 2007

MTP6Q-D868F-448FG-B6MG7-3DBKT
T3PVR-XX42X-T49DW-WGBG6-9FT73
TT3M8-H3469-V89G6-8FWK7-D3Q9Q
RVRY7-9H6W3-VBGF7-M7GQF-2X7TB
BHFYK-9RTKR-RV3J6-X669J-XQ3Q8
GM3C4-HQQJV-4TGMX-3R8CP-G928Q
KGFVY-7733B-8WCK9-KTG64-BC7D8
XC84W-M642D-2QDWY-YTKMM-RWJQW
TQ7MT-BQTJD-V4MJ6-J6KT8-RP2VW
HCFPT-K86VV-DCKH3-87CCR-FM6HW
V9mtg-3gx8p-d3y4r-68bq8-4q8vd
KGFVY-7733B-8WCK9-KTG64-BC7D8
GM3C4-HQQJV-4TQMX-3R8CP-G928Q
MTP6Q-D868F-448FG-B6MG7-3DBKT
kxfdr-7ptmk-ykyhd-c8fwv-bbpvw

FOR OFFICE ENTERPRISE 2007

VCWD4-Q2HTM-VKT6B-7V8J3-28K38
M2BX2-HQKQF-Q9Q7K-F2JQH-MDGHW
FXDKB-XJKJP-9B79T-8CMPB-QG938
KGFVY-7733B-8WCK9-KTG64-BC7D8
D8Y66-3Y4GK-G6Y3C-8G7R9-JTDQ8
V9MTG-3GX8P-D3Y4R-68BQ8-4Q8VD
KGFVY-7733B-8WCK9-KTG64-BC7D8
W2jjw-4kydp-2ymkw-fx36h-qyvd8
Vb48g-h6vk9-wj93d-9r6rm-vp7gt
Hcfpt-k86vv-dckh3-87ccr-fm6hw

OFFICE ULTIMATE 2007

J67F8-BB7GM-8VPH2-8YMXP-K49QQ
M247G-3Y738-69GD7-V6CF8-9KH4G
M2QKF-KDQ4R-YHQKD-M4YYK-GPWVD
WRWWX-G9MMD-X4B8X-7JQP3-CMD93
RYC22-PRMXB-8HP8W-384PD-GXHX3
VM98J-C9X4C-MM7YX-93G64-BJMK3


avast : W3083976R9962A0912-ZZT6LA5J
download avast 2014


Corel Draw
download

http://belazy.blog.com/

Billing (inventory) system for shops

Billing system for medium size shops

This system can help the company to avoid overstocking. When an organisation overstocks, money is wasted since procuring, storing, and accounting for unneeded items require time, space, and money which could have been used on more critical assets. Likewise, when under stocking occurs the organisation will more likely to only partly meet their mission or possibly not meet the mission at all. Also, a weak inventory control system is more prone to errors and fraud.
      Having advanced systems on sales and inventories makes the company more productive, efficient and convenient both to the company and its client. The system is meant to help people show to customers more relevant items, hoping to expedite   and increase the sales and most importantly to increase the profit of the company. With the aid of sales and inventory systems, management can easily make consistent, reliable, and timely decisions.

Our inventory software is designed for any business that desires a complete control over stock levels and inventory tracking. This inventory software can be used either as a simple inventory control system or a complete manufacturing solution.

The main modules are the following

·         Purchase Module

·         Sales Module

·         Inventory Module

·         Report Module

·         User Module (Employee, Customer and Vendor management)

There will be two types of user (on the basis privilege).

1.      Administrator :

2.      Employees :

log in screen

Please visit our site  proximoTech 

Offical fb page : Trade

Java Fx Login page example