' and ^ everywhere

[Tim in Portland]

Can anyone explain why either ' or ^ is in every cell within a workbook. It
doesn't show up if anyone else view the book, so it must be a local setting.
The characters do not effect formulas or numbers they're more like hidden
characters.

Tim in Porltand

[Ron Coderre]

Sounds like your computer is running Excel to emulate Lotus 123.

Assuming you don't want that, try this:
Tools>Options>Transition
Select:
Microsoft Excel Menus
Deselect:
Transition navigation keys
Transition formula evaluation
Transition formula entry
Then click [OK]

Does that help?
Ron


"Tim in Portland" <timothy_p_ryan@verizon.net> wrote in message
news:prgEe.63$S72.29@trndny06...
> Can anyone explain why either ' or ^ is in every cell within a workbook.
> It doesn't show up if anyone else view the book, so it must be a local
> setting. The characters do not effect formulas or numbers they're more
> like hidden characters.
>
> Tim in Porltand
>

[Dave Peterson]

And if I remember my 123,

^ centers the value in the cell.
' makes it text and left justifies it
" makes it text and right justifies it.

Tim in Portland wrote:
>
> Can anyone explain why either ' or ^ is in every cell within a workbook. It
> doesn't show up if anyone else view the book, so it must be a local setting.
> The characters do not effect formulas or numbers they're more like hidden
> characters.
>
> Tim in Porltand

--

Dave Peterson

[moi]

Lol
/ worksheet - column - set width...
/ data - query - input...
And wow, when version 3.0 was released, we had WYSIWYG for the first time,
on that fast, oh so fast 386's.
I forgot about the ^, ' and " but now I remember again and you're definitely
right, Dave.
Last week I was looking for the version 2.1 diskettes on the web - too bad,
I didn't find them.

Uh oh, I'm gettin' old...




"Dave Peterson" <petersod@verizonXSPAM.net> schreef in bericht
news:42E19BC8.C64DBF28@verizonXSPAM.net...
> And if I remember my 123,
>
> ^ centers the value in the cell.
> ' makes it text and left justifies it
> " makes it text and right justifies it.
>
> Tim in Portland wrote:
>>
>> Can anyone explain why either ' or ^ is in every cell within a workbook.
>> It
>> doesn't show up if anyone else view the book, so it must be a local
>> setting.
>> The characters do not effect formulas or numbers they're more like hidden
>> characters.
>>
>> Tim in Porltand
>
> --
>
> Dave Peterson

[Dave Peterson]

And that first WYSIWYG was a separate program, wasn't it. You couldn't edit in
that mode, IIRC--it has been a longgggggggg time.

Maybe it was an addin for 2.1????

moi wrote:
>
> Lol
> / worksheet - column - set width...
> / data - query - input...
> And wow, when version 3.0 was released, we had WYSIWYG for the first time,
> on that fast, oh so fast 386's.
> I forgot about the ^, ' and " but now I remember again and you're definitely
> right, Dave.
> Last week I was looking for the version 2.1 diskettes on the web - too bad,
> I didn't find them.
>
> Uh oh, I'm gettin' old...
>
> "Dave Peterson" <petersod@verizonXSPAM.net> schreef in bericht
> news:42E19BC8.C64DBF28@verizonXSPAM.net...
> > And if I remember my 123,
> >
> > ^ centers the value in the cell.
> > ' makes it text and left justifies it
> > " makes it text and right justifies it.
> >
> > Tim in Portland wrote:
> >>
> >> Can anyone explain why either ' or ^ is in every cell within a workbook.
> >> It
> >> doesn't show up if anyone else view the book, so it must be a local
> >> setting.
> >> The characters do not effect formulas or numbers they're more like hidden
> >> characters.
> >>
> >> Tim in Porltand
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

[Ron Coderre]

Yup...it was called "Always". Input to cells>toggle to Always>format
cells>toggle back to 123. Seems silly now, but it was the best we had back
then. Looking back, those days seem...um...quaint?

Ron


"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:42E1A7AF.6AAFE8BE@verizonXSPAM.net...
> And that first WYSIWYG was a separate program, wasn't it. You couldn't
> edit in
> that mode, IIRC--it has been a longgggggggg time.
>
> Maybe it was an addin for 2.1????
>

[Dave Peterson]

Good memory. That's bothered me since I forgot it 1492--right after the boat
trip!

Ron Coderre wrote:
>
> Yup...it was called "Always". Input to cells>toggle to Always>format
> cells>toggle back to 123. Seems silly now, but it was the best we had back
> then. Looking back, those days seem...um...quaint?
>
> Ron
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:42E1A7AF.6AAFE8BE@verizonXSPAM.net...
> > And that first WYSIWYG was a separate program, wasn't it. You couldn't
> > edit in
> > that mode, IIRC--it has been a longgggggggg time.
> >
> > Maybe it was an addin for 2.1????
> >

--

Dave Peterson