Leading ' Issue

cr2crf

New Member
Joined
Jun 19, 2013
Messages
40
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?
 
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
 
Upvote 0

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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?
1635856671822.png
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top