View Single Post
 
Old Yesterday, 11:44 PM
ArviLaanemets ArviLaanemets is online now Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 958
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

Format both columns as "0;-0;;@"
You can enter 0's, but they aren't displayed.
NB! the value of cell with entered 0 in it remains 0, Formatting cant change the value in cell (date format will be exception, as with it whenever the entered value can be interpreted as date, the Excel itself takes over and replaces the entry with date in current format) - it only affects how this value will be displayed!
Reply With Quote