Why do my fields start with an apostrophe?

[jmerwamer]

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.

 

[CLR]

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]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Dave F]

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

Dave

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


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

Dave

 

[Dave Peterson]

In xl2003, I'd toggle:

Tools|Options|Transition Tab|Uncheck Transition Navigation Keys

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