Converting date into plain text
Folks,
I have a small problem. Let's say I have January 22, 2004 in one cell. Now this is set up as a Date format. Is there a way I can convert it into text so that I can do, for example, a left() function that's going to ask for the first 3 characters in that cell..i.e. bring back "Jan". |
Converting date into plain text
You could...
But maybe it would just be easier to use: =text(a1,"mmm") to return that 3 character abbreviation. But you could use something like: =left(text(a1,"mmmm dd, yyyy"),3) To extract characters from the formatted value. Shams wrote: Folks, I have a small problem. Let's say I have January 22, 2004 in one cell. Now this is set up as a Date format. Is there a way I can convert it into text so that I can do, for example, a left() function that's going to ask for the first 3 characters in that cell..i.e. bring back "Jan". -- Dave Peterson |
Converting date into plain text
Hi
=TEXT(A1,"mmm") Arvi Laanemets "Shams" wrote in message ... Folks, I have a small problem. Let's say I have January 22, 2004 in one cell. Now this is set up as a Date format. Is there a way I can convert it into text so that I can do, for example, a left() function that's going to ask for the first 3 characters in that cell..i.e. bring back "Jan". |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com