Why do my fields start with an apostrophe?
 

Some lines of my spreadsheet will have an apostrophe before the entry. It's
not visible except in the function bar. Find and replace doesn't see it. I
didn't put it there.

Why do my fields start with an apostrophe?
 

It's just an indication that the cell is formatted as TEXT. Doesn't hurt
anything, doesn't print...........if you re-format the cell for a NUMBER
format, it should go away.

Vaya con Dios,
Chuck, CABGx3



"jmerwamer" wrote:

Some lines of my spreadsheet will have an apostrophe before the entry. It's
not visible except in the function bar. Find and replace doesn't see it. I
didn't put it there.

Why do my fields start with an apostrophe?
 

Hi Chuck,

I changed the formatting and it didn't go away. For my spreadsheets, it is
usually a green tab that indicates if a cell is formatted for text when it
contains numbers.
But in this case the cell will look normal like this with nothing around it:

Example

but in the function bar it will contain:

'Example

Any other thoughts?

Thanks,
Jamie

"CLR" wrote:

It's just an indication that the cell is formatted as TEXT. Doesn't hurt
anything, doesn't print...........if you re-format the cell for a NUMBER
format, it should go away.

Vaya con Dios,
Chuck, CABGx3



"jmerwamer" wrote:

Some lines of my spreadsheet will have an apostrophe before the entry. It's
not visible except in the function bar. Find and replace doesn't see it. I
didn't put it there.

Why do my fields start with an apostrophe?
 

Some lines of my spreadsheet

If it is not too many then selecting them and running this Macro will remove
the apostrophe:

Sub test()
Selection.Value = Selection.Value
End Sub

If you have dates in any of the cells and you use the British format then,
because VBA is American date system eccentric, it will convert the date to
that layout but because it then is not a readable date to your system it
will result in a text representation of the date.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"jmerwamer" wrote in message
...
Some lines of my spreadsheet will have an apostrophe before the entry.
It's
not visible except in the function bar. Find and replace doesn't see it. I
didn't put it there.

Why do my fields start with an apostrophe?
 

Another thing you can do is use the TRIM() function to remove
apostrophes...then copy, paste special values...

Dave

On Dec 21, 3:20*pm, jmerwamer
wrote:
Hi Chuck,

I changed the formatting and it didn't go away. For my spreadsheets, it is
usually a green tab that indicates if a cell is formatted for text when it
contains numbers.
But in this case the cell will look normal like this with nothing around it:

Example

but in the function bar it will contain:

'Example

Any other thoughts?

Thanks,
Jamie



"CLR" wrote:
It's just an indication that the cell is formatted as TEXT. *Doesn't hurt
anything, doesn't print...........if you re-format the cell for a NUMBER
format, it should go away.

Vaya con Dios,
Chuck, CABGx3

"jmerwamer" wrote:

Some lines of my spreadsheet will have an apostrophe before the entry. It's
not visible except in the function bar. Find and replace doesn't see it. I
didn't put it there.- Hide quoted text -

- Show quoted text -

Why do my fields start with an apostrophe?
 

So will copying a blank cell and then Paste Special Add into the original
cell

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dave F" wrote in message
...
Another thing you can do is use the TRIM() function to remove
apostrophes...then copy, paste special values...

Dave

On Dec 21, 3:20 pm, jmerwamer
wrote:
Hi Chuck,

I changed the formatting and it didn't go away. For my spreadsheets, it is
usually a green tab that indicates if a cell is formatted for text when it
contains numbers.
But in this case the cell will look normal like this with nothing around
it:

Example

but in the function bar it will contain:

'Example

Any other thoughts?

Thanks,
Jamie



"CLR" wrote:
It's just an indication that the cell is formatted as TEXT. Doesn't hurt
anything, doesn't print...........if you re-format the cell for a NUMBER
format, it should go away.

Vaya con Dios,
Chuck, CABGx3

"jmerwamer" wrote:

Some lines of my spreadsheet will have an apostrophe before the entry.
It's
not visible except in the function bar. Find and replace doesn't see
it. I
didn't put it there.- Hide quoted text -

- Show quoted text -

Why do my fields start with an apostrophe?
 

In xl2003, I'd toggle:

Tools|Options|Transition Tab|Uncheck Transition Navigation Keys

(I'd uncheck all those Lotus 123 settings.)

jmerwamer wrote:

Some lines of my spreadsheet will have an apostrophe before the entry. It's
not visible except in the function bar. Find and replace doesn't see it. I
didn't put it there.

--

Dave Peterson