What's difference in writing date as 18/10/2006 and '18/10/2006
 

What's difference in writing date as 18/10/2006 and '18/10/2006

What's difference in writing date as 18/10/2006 and '18/10/2006
 

The preceding apostrophe makes it text. You can't use it to calculate with.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ravi Garg" wrote in message ...
| What's difference in writing date as 18/10/2006 and '18/10/2006