#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 8
Default date not correct in cell

Hi
I formatted cell A1 to date cell
till sofar the date 01-11-06 appears as requested in that cell

When I copy A1 to B1 (B1=A1) it gives also the correct date

When I put in B1 the formule
=IF(D1="";"";"The date is ";A1) it shows The date is 39022

(programmed in Excel2003 and copied to Excel2000)
What is wrong
Please help
Thanks in advance
Ron

  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 8
Default date not correct in cell

Hi Dave

Yes that will do
(D1 is correct if that cell is not filled the formular will not
appears)

Strange situation same formular with other cells in the same sheet
are oke

Thanks
Ron





Dave Peterson schreef:

=IF(D1="";"";"The date is ";text(A1;"mm/dd/yyyy"))

Did you really mean to use D1 and A1?

wrote:

Hi
I formatted cell A1 to date cell
till sofar the date 01-11-06 appears as requested in that cell

When I copy A1 to B1 (B1=A1) it gives also the correct date

When I put in B1 the formule
=IF(D1="";"";"The date is ";A1) it shows The date is 39022

(programmed in Excel2003 and copied to Excel2000)
What is wrong
Please help
Thanks in advance
Ron


--

Dave Peterson


Reply
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
Empty Date Cell as Zero [email protected] Excel Discussion (Misc queries) 1 September 22nd 06 01:09 AM
if cell has date value how to calculate other cell values Excel User Excel Discussion (Misc queries) 2 August 22nd 06 01:15 AM
How do I copy a date in a worksheet cell to another worksheet? JennLee Excel Worksheet Functions 3 February 17th 06 06:38 PM
Changing Cell formats to date fields automatically PCLIVE Excel Worksheet Functions 3 April 12th 05 10:34 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 12:50 PM.

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

About Us

"It's about Microsoft Excel"