Karthik-Excelsior
Active Member
- Joined
- Mar 4, 2011
- Messages
- 313
Hi excel gurus,
Have you ever experienced this - you copy 'Dates' from one Excel sheet and paste them on to another, and the Dates become Numbers.
Sometimes, even after selecting them and choosing 'Currency' format doesn't help. Then, I mostly use the TEXT formula to get the date format.
Any idea, why this conversion happens, and how this can be averted?
Thanks,
Karthik
Have you ever experienced this - you copy 'Dates' from one Excel sheet and paste them on to another, and the Dates become Numbers.
Sometimes, even after selecting them and choosing 'Currency' format doesn't help. Then, I mostly use the TEXT formula to get the date format.
Any idea, why this conversion happens, and how this can be averted?
Thanks,
Karthik