| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ©¿©¬ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ©¿©¬ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ©¿©¬ |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ©¿©¬ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show Country Name at Each Row | Excel Worksheet Functions | |||
| Show Country Name in Each Row | Excel Worksheet Functions | |||
| country list | Excel Discussion (Misc queries) | |||
| List for country names | Excel Discussion (Misc queries) | |||
| Drop down box with country list | New Users to Excel | |||
Linear Mode
