Leading ' Issue

[cr2crf]

When converting a column of formulas to values, the results are the values with a leading apostrophe ( ' ). The values looks like this - 'CRASH. When I do the same operation in a co-workers identical spreadsheet it does not produce the leading apostrophe. The formula to produce the value is identical. Any clue?

 

[cr2crf]

Do you have the Transition navigation keys option checked under File - Options, at the bottom of the Advanced section? If so, and if the cells are left-aligned, you'll see the ' formatting marker.

No. it is not checked

 

[cr2crf]

When you say that it does not happen when a co-worker does it, are you both trying it on the EXACT same file?

exact is the same as IDENTICAL

 

[Joe4]

So there is something different about your computer then. You just have to figure out what that is.

Are ANY of the three LOTUS compatability check boxes checked?

 

[RoryA]

exact is the same as IDENTICAL

Not to me - identical implies you have two corresponding workbooks, whereas 'the exact same file' means you are both using the same single workbook.

 

[Joe4]

Not to me - identical implies you have two corresponding workbooks, whereas 'the exact same file' means you are both using the same single workbook.

Rory is absolutely right here, and that is why I asked it the way I did.

In order to zero in on the problem, we need to remove all the variances. So you need to test the EXACT same file, not a copy or a similar one.

 

[cr2crf]

When you say that it does not happen when a co-worker does it, are you both trying it on the EXACT same file?

exactly is the same as IDENTICAL

 

[cr2crf]

Not to me - identical implies you have two corresponding workbooks, whereas 'the exact same file' means you are both using the same single workbook.

Sorry that wasn't meant for you

 

[RoryA]

Sorry that wasn't meant for you

Notwithstanding that, you seem to be missing the point I was making. The two phrases do not have the same meaning.

 

[Joe4]

exactly is the same as IDENTICAL

You took that word completely out of context, and missed some very important words. I said:

When you say that it does not happen when a co-worker does it, are you both trying it on the EXACT same file?

That clearly involves one SINGLE file.

"Identical" involves the comparison of TWO or more things, like "identical twins". You would never say a file is identical to itself - you would say it is identical to some other file.

I have no more interest in quibbling over semantics with you (especially when it is pretty clear what we are asking), so I will bow out.

 

[cr2crf]

You took that word completely out of context, and missed some very important words. I said:

That clearly involves one SINGLE file.

"Identical" involves the comparison of TWO or more things, like "identical twins". You would never say a file is identical to itself - you would say it is identical to some other file.

I have no more interest in quibbling over semantics with you (especially when it is pretty clear what we are asking), so I will bow out.

Apologies to both of you. I was in the middle of a company crisis and did not explain myself well. Nothing between my ears were working that day. You were both correct and I just wasn't reading anything right that day. Problem was solved at my end.

When i said identical, I meant we each were working on two copies of the same file that started the day as one and then was copied. The problem was in a new version of our data that IT put out to one of us but not the other.

Again, sorry for my confusion.