Formatting in excel spreadsheet

[shilpashetty_80]

Hi There!

I noticed that some of the fields in the excel spreadsheet are getting added with an apostrophe at the beginning of the field. For e.g if I type in CABLE in a cell, it actually shows up as 'CABLE at the top of the spreadsheet, in the formula bar.

I checked to see the formatting and it is formatted as General. Not sure why the apostrophe is getting added. Any light you can throw on this is appreciated.

Thanks in advance!
Shilpa

[Ron Coderre]

Try this:

From the Excel Main Menu:
<tools><options><transition tab>
UNcheck everything!

Does that help?

[shilpashetty_80]

Hi Ron,

Tks for responding.
Everything is unchecked in the transition tab but unfortunately it still doesn't seem to be removing the apostrophe.

any other ideas perhaps??

Thanks!
Shilpa

[Ron Coderre]

Using <tools><options><transition tab> should prevent
apostrophes from be prepended to new text.

To remove the apostrophes from existing text...
Copy an EMPTY CELL

Select the range of text cells that have preceding apostrophes.

From the Excel Main Menu:
<edit><paste special>
...Check: Add
...Click: [OK]

Does that help?