Excel help

slipd · 15 Aug 2011 at 20:43

Hi guys,

I've been working on spreadsheet which I've been sent from work and I'm having a few problems with what I type... basically every time I type 'and' it is automatically replaced with 'N/A'. I'm guessing its something that's been set in the sheet but I can't work out how you get rid of it

Any ideas?

Participant · 15 Aug 2011 at 20:51

Change the cell properties to be text. It thinks you're trying to enter an 'AND' formula.

slipd · 15 Aug 2011 at 21:09

Robbie G said:
Change the cell properties to be text. It thinks you're trying to enter an 'AND' formula.

I think I know what you mean mate, but I don't think its a formula issue - it doesn't look like the normal "#N/A!" it appears like some kind of 'find and replace' has been set...

Participant · 15 Aug 2011 at 21:25

Ah right. If Excel 2007 or newer, go to the data tab in the ribbon and check data validation. Someone might have set validation to return N/A unless an approved entry is made in the cell.

slipd · 15 Aug 2011 at 21:41

Robbie G said:
Ah right. If Excel 2007 or newer, go to the data tab in the ribbon and check data validation. Someone might have set validation to return N/A unless an approved entry is made in the cell.

I'm using 2003 and I think the file was created in 2003...

Cheers mate!

Participant · 15 Aug 2011 at 21:50

Go to the data menu and check validation rules.

slipd · 16 Aug 2011 at 18:00

It was bloody AutoCorrect...

No idea when I would have changed that?!

Thanks mate!