Greetings,
1- I have entered 1.1.2015 into A1 cell.
2- I am looking at A1 cell and see 1.1.2015.
3- Right click A1 cell >> edit cells >> date >> 1 January 2015 Thursday
4- I am looking at A1 cell and see 1 January 2015 Thursday
I want to see 1 January 2015 Thu instead of 1 January 2015 Thursday in the A1 cell.
So, I want to see first three letter of the day name.
I need a vba code for this.
Thank you very much.
Last edited by HerryMarkowitz; 07-14-2015 at 10:46 AM.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
maybe so
Please Login or Register to view this content.
Hi nilem,
Good to see you again.
Solved. Thank you.
Another question is I want to see 1 1 2015 Thu instead of 1 January 2015 Thu.
Hi HerryMarkowitz,
Good to see you too
"mmmm" gives January
"mmm" - Jan
"mm" -01
so
Please Login or Register to view this content.
Good!
But I have extra question
Yes, I am seeing 1 1 2015 Thu now.
But I want to see 1 1 2015 Per now. (Per is the first three letter of Turkish Thursday).
"d" 2Please Login or Register to view this content.
"dd" 02
"ddd" Вт (in Russian)
"dddd" Вторник
Perfect!
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks