Andrew...you are missing what Glenda said...she said she is typing that formula in a TEXT formatted field...even with the equal sign, if you format a cell as text, it will show the formula and not the result of the formula. That's why I told her to change it to general or number or something...but it can't be text. Linda F. Johnson Linda's Computer Stop http://personal-computer-tutor.com All outgoing mail checked by Norton AV. If you received a "bug" that looked like it came from me, it did NOT! -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Andrew the Owl Sent: Friday, January 27, 2006 7:21 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Excel & Word GLENDA WELLS wrote: > In Excel I tried to get the value so used functions left, mid > and right in a text formatted field. When I do that though > what I see in the cell is the formula, not the result. > > I tried the control + ` to switch between formula and value > but that did not work. You did, I suppose, put an equals sign first? I regret I all too frequently leave it out ;) Andrew ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************