LinkBack URL
About LinkBacks
Hello,
I am wondering if I am able to display dates as text. Example: If I have a date that displays as 5/6/2014 is there anyway I can get it to display as 562014 as text?
Hello,
I am wondering if I am able to display dates as text. Example: If I have a date that displays as 5/6/2014 is there anyway I can get it to display as 562014 as text?
you can format using custom and just remove the "/" which will get you 562014.
EDIT: it will appear in the cell as that, but will still appear in the formula bar as 5/6/2014 if that is ok.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Misunderstood your problem. Solution offered not appropriate.
Last edited by newdoverman; 05-21-2014 at 11:38 AM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Ctrl+H to find and replace then in the find box type / and leave replace box empty. Then replace all.
Once done select the cells and change the formatting to general.
You can use TEXT the formula --- =TEXT("5/6/2014","mdyyyy"))
Or if cell A1 is 5/6/2014, use =TEXT(A1,"mdyyyy")
Last edited by mcouture; 05-21-2014 at 11:43 AM. Reason: correct formulas
You don't need to remove anything just format custom mdyyyy and you will get 562014
or formula
=SUBSTITUTE(TEXT(A1,"mdyyyy"),"/","")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
This will produce the result you want but in another cell:
Formula:
=TEXT(DATE(YEAR(A1),MONTH(A1),DAY(A1)),"dmyyyy")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks