Convert date to text

  • Thread starter Thread starter sw
  • Start date Start date
S

sw

How can I convert a date into TEXT format to use in a
Pivot Table e.g. If I format the cell to be text it shows
a number. Even though my dates are shown as January 1999
it displays in the formula bar 01/01/99 when I want it to
show only January 1999.

Any ideas?
 
Hi,

Use

=TEXT(A1,"mmmm yyyy")

where A1 is the cell which has dates. then use the cell which has dates
in the format of January 1999 to form a pivot.

Regards

Govind.
 
Hi
you can't change the display in the formula bar. The only way would be
to change the format to text with the TEXT function. But why do you
want to change the formula display?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting text format of time/date into Excel time/date for subtr 5
Excel 2007 4
Problem Converting date to month in text for use in pivot table 2
Which is the best MBOX Converter Tool different formats conversion? 4
Dates from Text 4
text to date..! 3
converting text into years 4
Convert table by date to array 5

Back
Top