Forum Discussion
Excel doesnot recognize the date until duble click
My apologies SergeiBaklan
I mean I actually I want values in the "/" format only!! I do not want the - format, I don't know why only some values get converted when I am cutting and pasting all the mm/dd/yyyy values ?!? Any guesses?
Thank you
[Sorry I wasn't clear]
These are separate. First, most probably you have dates as texts and you need to convert them to dates (actually they are numbers in Excel). You may check do you text or date by using =ISTEXT(A1) from any empty cell.
Once you converted texts to dates you may apply any desired format to them, that's only visualization of numbers behind.
In these two cells is the same date, but to the second I applied another format
- Thank you Sergei,
But that begs the question.. When I am copying as text & pasting, why are only some values getting pasted as text whilst the others as numbers? That is what is baffling me!!
If it was one or the other I can understand & easily format the entire range, but Excel is only converting some of them, which makes it almost impossible to format!
Any guesses/ideas/clues anyone? Please, thank you!
Kind regards,
Nikhil PrabhuIf you copy/paste from other source Excel automatically converts what it could recognize and keep unchanged the rest. If you copy/paste from source where dates are in another locale, better to format destination column as texts, paste values to it, apply general format and convert text to dates after that.
- Ok, Thank you