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.
[Solved] VLOOKUP returns a number instead of a date
[Solved] VLOOKUP returns a number instead of a date
Last edited by Hagar Delest on Tue Jan 29, 2013 10:40 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OPENOFFICE 3.1 WINDOWS 7
-
MrProgrammer
- Moderator
- Posts: 5477
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: VLOOKUP
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.
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.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.8, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.7.8, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: VLOOKUP
hi and thanks.
it is great to be in this forum!
thanks for the answer.ofcource it worked great!
it is great to be in this forum!
thanks for the answer.ofcource it worked great!
OPENOFFICE 3.1 WINDOWS 7