Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default Date shows as a number

I have a date in cell E2 formatted as 2011/08/09

In cell G2 I have a small formula
="%changeNextPaydate( "&A2&"'"&E2&"' );"

This should display as %changeNextPaydate( 1001552205
‘2011/08/09’ );
But the date in cellE2 shows as the numeric ’40764’
giving me %changeNextPaydate( 1001552205
‘40764’ );

Does anybody know how I can correct this please.

With thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default Date shows as a number

Hi Bob,

Am Tue, 7 Jun 2011 12:56:46 -0700 (PDT) schrieb Bob:

I have a date in cell E2 formatted as 2011/08/09

In cell G2 I have a small formula
="%changeNextPaydate( "&A2&"'"&E2&"' );"

This should display as %changeNextPaydate( 1001552205
?2011/08/09? );
But the date in cellE2 shows as the numeric ?40764?
giving me %changeNextPaydate( 1001552205
?40764? );


try:
="%changeNextPaydate( "&A2&"'"&TEXT(E2,"YYYY/MM/DD")&"' );"


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
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
when I type a long number it shows up as smaller number and + SandyC Excel Discussion (Misc queries) 5 March 17th 10 08:47 PM
Cell that is formated for Date shows a diffrent number Haider Excel Discussion (Misc queries) 2 December 8th 09 09:26 PM
when I enter a number, only ###### shows? Greg's excel questions Excel Worksheet Functions 3 July 30th 08 02:37 AM
Number 6 shows as s Zelfan Excel Discussion (Misc queries) 3 June 19th 06 03:30 AM
Excel: I enter date and format for date, but shows as number spohar Excel Discussion (Misc queries) 2 March 10th 06 09:40 PM


All times are GMT +1. The time now is 05:56 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"