![]() |
|
#1
|
|||
|
|||
|
I have noticed this problem in every version of Excel.
Format a cell as Text then later you decide you want the cell to be General and you change it. Enter a formula in the cell, Excel still treats it like a Text formatted cell. Press F2 and press enter and the formula calculates. Press F2 again and Excel changes the format back to Text. Anyone know how to fix this? |
| Tags |
| excel cell format |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2007 cell format help!!!
|
Raner | Excel | 4 | 06-17-2013 11:13 PM |
Outlook 2010 - Mail not staying in Inbox
|
NRBCox | Outlook | 2 | 11-28-2011 09:29 PM |
| Cell # format | markg2 | Excel | 4 | 10-23-2011 09:38 PM |
| Pictures Not Staying In Position | BrazzellMarketing | Word | 3 | 10-06-2011 06:54 AM |
Macro not staying true
|
oluc | Word VBA | 4 | 11-21-2010 08:10 AM |