Page 1 of 1
[Solved] VLOOKUP returns a number instead of a date
Posted: Tue Jan 29, 2013 8:35 pm
by Nik30
Hi. i am trying to use vlookup and instead of returning me a date (9/8/13) it returns (41495). any ideas?
actually it returns all dates with a weird number.
Re: VLOOKUP
Posted: Tue Jan 29, 2013 8:44 pm
by MrProgrammer
Hi, and welcome to the forum.
41495 is the correct integer for August 9, 2013. Just change the cell's style/format. Read section
3. Dates in cells in
Ten concepts that every Calc user should know.
If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Re: VLOOKUP
Posted: Tue Jan 29, 2013 9:00 pm
by Nik30
hi and thanks.
it is great to be in this forum!
thanks for the answer.ofcource it worked great!