Prev: Excel 2007: Can it SUMIF( ) using color as a condition ?
Next: 2007 Excel file formats
From: dudemanmax on 20 Dec 2009 06:06
Excel 2007.

I need to have some cells with a @ character at the start of them. As soon
as I add it and move out of the cells it gives me a "function not valid"
error. I have tried turning off all sorts of autocorrect and other options
to no avail. How can I get that to stop trying to change it and leave it be?

For example I want the cell to say @image
From: trip_to_tokyo on 20 Dec 2009 06:33
Format the cell as text and you will be able to input it.

Pleased hit Yes if my comment has helped.

"dudemanmax" wrote:

> Excel 2007.
>
> I need to have some cells with a @ character at the start of them. As soon
> as I add it and move out of the cells it gives me a "function not valid"
> error. I have tried turning off all sorts of autocorrect and other options
> to no avail. How can I get that to stop trying to change it and leave it be?
>
> For example I want the cell to say @image
From: trip_to_tokyo on 20 Dec 2009 06:39
. . so in EXCEL 2007 that would be:-

- Home group

- Font then click on the arrow in the lower right hand corner

- Format Cells should launch

- Number tab

- select Text on the left hand side (by clicking it)

- OK

You should then be able to get @image into the cell.

Please hit Yes if my comments have helped.

Thanks!


"dudemanmax" wrote:

> Excel 2007.
>
> I need to have some cells with a @ character at the start of them. As soon
> as I add it and move out of the cells it gives me a "function not valid"
> error. I have tried turning off all sorts of autocorrect and other options
> to no avail. How can I get that to stop trying to change it and leave it be?
>
> For example I want the cell to say @image
From: Ron de Bruin on 20 Dec 2009 07:14
Enter it like this

'@

You not see the ' in the cell

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"dudemanmax" <dudemanmax(a)discussions.microsoft.com> wrote in message news:7EB64F88-200F-45F9-A132-DF32C18D10C3(a)microsoft.com...
> Excel 2007.
>
> I need to have some cells with a @ character at the start of them. As soon
> as I add it and move out of the cells it gives me a "function not valid"
> error. I have tried turning off all sorts of autocorrect and other options
> to no avail. How can I get that to stop trying to change it and leave it be?
>
> For example I want the cell to say @image
From: Mike H on 20 Dec 2009 07:18
Hi,

Enter an apostrophe ' before you enrte @. It won't show up in the cell.

Mike

"dudemanmax" wrote:

> Excel 2007.
>
> I need to have some cells with a @ character at the start of them. As soon
> as I add it and move out of the cells it gives me a "function not valid"
> error. I have tried turning off all sorts of autocorrect and other options
> to no avail. How can I get that to stop trying to change it and leave it be?
>
> For example I want the cell to say @image
 |  Next  |  Last
Pages: 1 2
Prev: Excel 2007: Can it SUMIF( ) using color as a condition ?
Next: 2007 Excel file formats