How to switch off automatical change data type?

  • Thread starter Thread starter Min
  • Start date Start date
M

Min

Hi, I input "1/4" or something like that, actually, it's a string, but Excel
is to smart to change it to Jan 4, 2004. I would like to know how to stop
this automatic change? What's the code to do so? As I am actually using VB
code to operate Excel.
Thank you!
 
Hi
either format the cell as 'Text' or preced your entry with an
apostrophe. e.g.
'1/4
 
Back
Top