Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when I type a long number it shows up as smaller number and + | Excel Discussion (Misc queries) | |||
Cell that is formated for Date shows a diffrent number | Excel Discussion (Misc queries) | |||
when I enter a number, only ###### shows? | Excel Worksheet Functions | |||
Number 6 shows as s | Excel Discussion (Misc queries) | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) |