LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default changing date value to date

Hello,
I would be very greatful if anyone can give me a solution to my problem. My
problem is: what is the formula to convert the date vale (for example:39124)
to date ( for example: 11-Feb-07)?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing date and time to date only canuckinnj Excel Worksheet Functions 3 March 23rd 07 12:41 AM
Report Date - Date Recv = Days Late, but how to rid completed date MS Questionnairess Excel Worksheet Functions 1 January 24th 07 11:05 PM
Cell contents changing to date and not date George Applegate Excel Worksheet Functions 3 October 17th 06 10:53 PM
Changing date from =NOW() to Creation Date Kjell Forssen Excel Worksheet Functions 4 April 17th 06 06:18 PM
When I open my past invoice it keeps changing date to todays date Stop date changing to todays in Excel Excel Worksheet Functions 2 October 7th 05 04:54 PM


All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"