A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

@ and "function not valid" error (Excel 2003)



 
 
Thread Tools Display Modes
  #1  
Old September 2nd, 2005, 06:10 AM
Acert93
external usenet poster
 
Posts: n/a
Default @ and "function not valid" error (Excel 2003)


I am using Excel 2003 as a spreadsheet for a vocabulary list for
Biblical Hebrew. The first column has the word, second a gloss
definition, third frequency, and so forth.

My problem is the Hebrew font I am using is represented by the *@* key.
In other words the letter "A" in this font is written with the "@" key.
The problem is Excel expects a forumula and wants to perform a function
when it sees

@lf

When this is just a word. Unfortunately Excel wont allow me to keep the
data in the cell and keeps giving me the function error.

How can I disable this feature? I am not doing any math or accounting,
I am just using Excel as a spreadsheet to keep all the data.

Thanks


--
Acert93
------------------------------------------------------------------------
Acert93's Profile: http://www.excelforum.com/member.php...o&userid=26914
View this thread: http://www.excelforum.com/showthread...hreadid=401386

  #2  
Old September 2nd, 2005, 07:17 AM
Ken Wright
external usenet poster
 
Posts: n/a
Default

Try this - Precede your entries with an apostrophe, or format your cells as
TEXT before you enter data.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Acert93" wrote in
message ...

I am using Excel 2003 as a spreadsheet for a vocabulary list for
Biblical Hebrew. The first column has the word, second a gloss
definition, third frequency, and so forth.

My problem is the Hebrew font I am using is represented by the *@* key.
In other words the letter "A" in this font is written with the "@" key.
The problem is Excel expects a forumula and wants to perform a function
when it sees

@lf

When this is just a word. Unfortunately Excel wont allow me to keep the
data in the cell and keeps giving me the function error.

How can I disable this feature? I am not doing any math or accounting,
I am just using Excel as a spreadsheet to keep all the data.

Thanks


--
Acert93
------------------------------------------------------------------------
Acert93's Profile:
http://www.excelforum.com/member.php...o&userid=26914
View this thread: http://www.excelforum.com/showthread...hreadid=401386



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SPELL CURRENCY FUNCTION Rajesh Using Forms 1 October 1st, 2005 11:04 PM
What is proper VBA reference for Trim function in Acc 2003? Hines86 General Discussion 4 September 16th, 2005 07:37 PM
Attaching Code DS General Discussion 2 August 22nd, 2005 11:21 PM
Excel 2003 worksheet name function? eddie_zoom Worksheet Functions 3 June 16th, 2005 11:46 PM
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 General Discussion 4 June 14th, 2005 07:34 AM


All times are GMT +1. The time now is 12:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.