typing 'Up Country' ends up as Up Country' ?

[Martin ©¿©¬]

hI
When typing 'Up Country' into a cell it ends up as Up Country' when I
tab to the next cell, However, if I type " Up Country" it sticks

Tried this in several cells with same result
Anyone know what is happening & how to fix please?

 

[Dave Peterson]

Start with two apostrophes.

Excel sees the first one as an indicator that the entry should be treated as
text--like with credit card numbers.

 

[Martin ©¿©¬]

Start with two apostrophes.

Excel sees the first one as an indicator that the entry should be treated as
text--like with credit card numbers.

Thanks Dave, that something else I've learned today

 

[Jacob Skaria]

Which control are you using. Once you get the value to a variable; say dtValue

Msgbox Format(dtValue,"dd,mm,yyyy")

 

[Jacob Skaria]

Oops.. The below is a wrong post