Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 06-04-2018, 10:23 PM
ArviLaanemets ArviLaanemets is offline Display Formula in Once Cell, Result in Another Windows 8 Display Formula in Once Cell, Result in Another Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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
into free column, copy it down, copy the range with formulas and overwrite values in formatted column with PasteSpecial>Values.

With one or couple of cells only, simply double-click on cell, or activate it and press F2, and then press Enter.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Display Formula in Once Cell, Result in Another Formula result not displaying in cell (but f9 works) 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
Display Formula in Once Cell, Result in Another Show result of formula as a value in another cell Steve_D Excel 4 10-12-2014 07:38 PM
Display Formula in Once Cell, Result in Another If formula result is negative then display text 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft