 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Help with formula
I have 2 pages Page 1 is booking form In page 2 I am doing this ='Booking Form '!J11 This refers to a name on the booking form, however it shows ='Booking Form '!J11 instead of John Smith. This works ok for the other cells. What am I doing wrong? On page 2 I press = and then click on the cell J11 on the `booking form` page and press enter. thanks It sounds like the cell is formatted as TEXT. Change the format to GENERAL. Then, just double click on the cell in question then hit ENTER and it should be Ok.  SignatureBiff Microsoft Excel MVP >I have 2 pages > Page 1 is booking form [quoted text clipped - 7 lines] > > thanks Hello there. Two things. 1) The cell is formatted as text. (change the cell formatting) and or there is a ' key just before the = sign. 2) Your formula view is showing? Hold down CTRL and hit the grave accent key = ` (usually found under the ESC key). Other then that, based on the information provided not really sure... Hope that helps. -Imonit > I have 2 pages > Page 1 is booking form [quoted text clipped - 7 lines] > > thanks I have tried all that is suggested but still no Joy, I tried the grave accent key and this shows all the formulas to be the exact same in other cells (apart from cell number change). It is still showing the formula view, I have also checked the formatting of the cell.(general) I am doing everything exactly as I am doing for other cells but still wont work. Hello there. Two things. 1) The cell is formatted as text. (change the cell formatting) and or there is a ' key just before the = sign. 2) Your formula view is showing? Hold down CTRL and hit the grave accent key = ` (usually found under the ESC key). Other then that, based on the information provided not really sure... Hope that helps. -Imonit On May 12, 4:10 pm, "S" <vir...@blueyonder.co.uk> wrote: > I have 2 pages > Page 1 is booking form [quoted text clipped - 8 lines] > > thanks After re-formatting the cell to General, you must re-enter the formula. F2 then ENTER Gord Dibben MS Excel MVP >I have tried all that is suggested but still no Joy, I tried the grave >accent key and this shows all the formulas to be the exact same in other [quoted text clipped - 32 lines] >> >> thanks Thanks the F2 then enter done it, thanks > After re-formatting the cell to General, you must re-enter the formula. > [quoted text clipped - 41 lines] >>> >>> thanks Good to hear. Gord >Thanks the F2 then enter done it, thanks > [quoted text clipped - 43 lines] >>>> >>>> thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.