![]() |
#5
|
|||
|
|||
![]()
When you change the format of cell/range, the change will be actual only after you edit the cell(s). Until then the old format is applied really.
So when you have e.g. a column with numbers or dates formatted as text, and you format the column to General or Date, after formatting the column you have to edit all entries in column. The fast way is enter 0 or 1 into some free cell elsewhere, copy the cell, and then PasteSpecial>Add or PasteSpecial>Multiply the formatted column. When you want to format numeric column to text, a foolproof way is after formatting to enter the formula Code:
= "" & CellReference With one or couple of cells only, simply double-click on cell, or activate it and press F2, and then press Enter. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
nath1235 | Excel | 4 | 10-06-2017 12:42 PM |
Perform calc in active cell then highlight based on formula result | grexcelman | Excel Programming | 4 | 01-12-2015 11:00 AM |
![]() |
Steve_D | Excel | 4 | 10-12-2014 07:38 PM |
![]() |
oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |