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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
@ 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
|
|||
|
|||
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 | |
|
|
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 |