LinkBack URL
About LinkBacks
Hi
please help me format the value in the cell into date.
Hi
please help me format the value in the cell into date.
Hi,
You need to enter
31/10/2012
or whatever your region settings are for the d/m/y separators
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
hI tRY
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
and you must know if Excel treat your date as text string (aligning automatically to left) or real date (aligning automatically to right side) you must get rid of manual alignment - now u set center so u dont know if Excel changed format in this cell. Someone more experienced should confirm that.
Just to be clear the original workbook does have B1 set to a date format so the only thing necessary is to enter the date with the correct separators that are identified in your regional settings. See post #2
Since the cell is formatted correctly there's no need to use a string slicing helper column just to coerce a date number from the string.
Using your sample, all that was required was to select the column where the date is and use Find and Select, Replace, Find What: - Replace with: / and the date was correctly converted into an Excel date.
<---------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
hi
boopathiraja method worked for me. Strangely I couldn't do the find & replace method or any other.
Last edited by pannam; 10-20-2014 at 04:25 AM.
Hi,Thanks for the feedback, If your Query Solved, You can mark the thread as solved and (preferably) say thanks to those who helped by clicking the Add Reputation button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks