View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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