Previous Topic Next Topic

Month and year format in forms in excel

Closed
kishore.koka Posts 4 Registration date Sunday September 29, 2013 Status Member Last seen November 7, 2017 - Nov 3, 2017 at 07:54 AM
kishore.koka Posts 4 Registration date Sunday September 29, 2013 Status Member Last seen November 7, 2017 - Nov 7, 2017 at 09:21 AM
Hello,
Hello sir
I am using forms to enter data. In form i used drop down list function to select particular month from pre-entered months from Name list in another sheet. When i am entering the data i will get pre entered month in the format of "MMM-YY" and i have to select one. Here i am getting numbers instead of "MMM-YY" format. How to solve this
Kindly help in this regard

Kishore
Related:

2 responses

Answer 1 / 2
Blocked Profile
Nov 3, 2017 at 01:06 PM
Please post a screen shot of the value you are getting back.

Does the cell that you are pasting into have Date format applied?
0
kishore.koka Posts 4 Registration date Sunday September 29, 2013 Status Member Last seen November 7, 2017
Nov 4, 2017 at 04:36 AM
sir
Name list data is formatted in English-US with "MMM-YY" format. Cell that to be updated are also Formatted in English-US with "MMM-YY" format. While updating in forms the cell appears in numbers (i.e. Excel Date numbers)
Hope i made it clear to you sir.
0
Blocked Profile
Nov 6, 2017 at 04:36 PM
Ok, so post please.
0
Answer 2 / 2
kishore.koka Posts 4 Registration date Sunday September 29, 2013 Status Member Last seen November 7, 2017
Nov 7, 2017 at 09:21 AM
Hello
how to post a screen shot in this reply can you help me. if it is possible kindly give email id to send through mail.

with regards
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses