View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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.