LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
couriced
 
Posts: n/a
Default problem: formula appears as text


Hello...I'm stumped....

I am entering a simple formula: =RIGHT(A2,2) in a cell. The sheet has
data on it but not a whole lot going on. I have tried formatting the
cell itself, the column, and the entire sheet a number of
ways...however, the formula appears in the cell as =RIGHT(A2,2)...as if
were a text entry...it won't actually just turn into a formula and do
it's thing.

Thanks in advance for response....


--
couriced
------------------------------------------------------------------------
couriced's Profile: http://www.excelforum.com/member.php...o&userid=26900
View this thread: http://www.excelforum.com/showthread...hreadid=473112

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text in formula bar is not displaying in cell Mike Excel Discussion (Misc queries) 0 August 29th 05 09:47 PM
Combine Formula and static Text Beginer Excel Discussion (Misc queries) 2 August 23rd 05 06:31 AM
formula OR text Bob Jones Excel Discussion (Misc queries) 5 August 15th 05 07:53 PM
Copy an Drag cell Formula Problem Nat Excel Discussion (Misc queries) 1 June 20th 05 03:24 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"