Problem with vlookup

[clifford_ayala]

Hello currently transfering some files on the other sheet, attached is the sample of my workbook environment. As you can see i had a problem with vlookup it only return round off output not the exact date like on the file1. also i might add that if i try to put 0001 on the account # it only becomes 1..how should i do it? sorry for this noob post as i am not that really versed on excel

[canapone]

Hi,

please see the file attached

You could format numbers as 0000 (see the example)

The VLOOKUP is OK, maybe you have to copy the format from column B of "file" sheet

Regards

[rajeshturaha]

Hi Cifford

You just have to format the cells.
1. In File 2 #c2 format the cell as Date & Time from format cell, as dd-mm-yy hh:mm
2. in file 1 #a1 format the cell as number, then select custom in type put 0000.
Plz see the attachment

[etaf]

for account number
Use custom format and put
0000
that will add the leading zero to a 4 digit number
ie 0001
or
0025

also custom format the date the same as file sheet

DD/MM/YYYY HH:MM

[clifford_ayala]

hi Guys Thanks for all your replies, its almost there :D..but how do i format it? i did right click + format cell the changed it to DD/MM/YYYY HH:MM...yes it do change but still it's giving me same results the decimal thing i first present..

about the file1 0000 problem..its now working fine

[etaf]

that should work - I changed your example OK

right click
format
custom
DD/MM/YYYY HH:MM

you need to apply that format to all the column
should change when copying the cell down

[clifford_ayala]

Sorry for the late reply everyone, YES thanks i'll give rep to all those who respond here, they are all correct it's just me who is slow to pickup when it comes to excel and i really appreciate the details and time everyone spent here..thanks :D