[Solved] Strange behaviour of spreadsheet

[arnoldr]

I have a multipage spreadsheet which I am using to keep track of applicants to a golf tournament. I am trying to generate a new page which will list the players alphabetically along with the information about where to start.

The information is available on a page labelled "entrants", where the names are in columns A and B and the start location is in column L. Using the formula in the new page of =entrants.A# and =entrants.B# works as expected, the names appear in each cell. However when I enter the formula =entrants.L# for the start location, the result in each cell is simply the text of the formula.

I have checked the format of the cells where I placed the formula and nothing appears strange. Can anyone tell me what the problem could possibly be and how I can fix it?

Thank you,

Arnold Roth

Edit: Email removed; Hagar, Moderator.

[robleyd]

I enter the formula =entrants.L# for the start location, the result in each cell is simply the text of the formula.

If the format of that cell(s) was set as Text then this will happen. If this is the case, one solution is to change the cell format to General and re-enter the formulae, as they won't magically change from Text to Formula when you change the cell format.

Edit: I suggest you remove your email address from your post, unless you want to receive lots of emails from Nigerian princes and people offering you 'enhancement' medications You might also consider upgrading your version of Office to the latest version.

[arnoldr]

Thanks, David. Unfortunately, that doesn't seem to be the cause of my problem. The format on the cells on the page I'm trying to create are default (not TEXT) and the cells I'm trying to copy
are as well. Thanks for removing my email address. I put that there thinking I would get replies by email and that my email address had recently changed.

Do you have any other suggestions? Thanks again.

[Villeroy]

menu:Tools>Options>Calc>View: Show formulas = OFF

[arnoldr]

I solved the problem. Deleted the new sheet and replaced it with another. Then everything worked OK. I don't know why but at least I can proceed. Thanks again for the help.