TEXT problem...

[Mark]

Hello.

I have a cell with the following formula:

TEXT(e2,"mmmm dd, yyyy (CSC)")

cell e2 contains a date formatted value, "March 27, 2004"

Question, although the formula appears to work in terms of
converting the date to a text datg (for manipulation
later), why does the result yield "March 27, 2004 (C0C)"
instead of "March 27, 2004 (CSC)"?

For some reason, the function is replacing my 'S' for a
zero (0).

Any ideas?

Mark

 

[Norman Harker]

Hi Mark!

Its because the S is being interpreted as seconds. Since you
(presumably) have a naked date in E2 without a time, the seconds are
0.

To get what you want use:

=TEXT(e2,"mmmm dd, yyyy")&" CSC"


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Mark]

Excellent - thank you very much Norman.

Mark

-----Original Message-----
Hi Mark!

Its because the S is being interpreted as seconds. Since you
(presumably) have a naked date in E2 without a time, the seconds are
0.

To get what you want use:

=TEXT(e2,"mmmm dd, yyyy")&" CSC"


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.

 

[Norman Harker]

Hi Mark!

Always pleased to help. Come back soon!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.