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

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?
--
Martin
©¿©¬

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

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, ©¿©¬, @nohere.net wrote:

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?
--
Martin
©¿©¬

--

Dave Peterson

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

On Fri, 08 May 2009 09:14:35 -0500, Dave Peterson
wrote:

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
--
Martin
©¿©¬




Martin, ©¿©¬, @nohere.net wrote:

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?
--
Martin
©¿©¬

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

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

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

--
If this post helps click Yes
---------------
Jacob Skaria


"Martin ©¿©¬ @nohere.net" wrote:

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?
--
Martin
©¿©¬

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

Oops.. The below is a wrong post
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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

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

--
If this post helps click Yes
---------------
Jacob Skaria


"Martin ©¿©¬ @nohere.net" wrote:

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?
--
Martin
©¿©¬