View Single Post
 
Old 03-20-2018, 07:53 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
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

Formatting according NBVC's advice must be dome before data are written into column. Currently Excel interprets entered numbers as date texts, and converts them to dates (Excel date is number of days from 01.01.1900), except a couple of them which excel can't convert.

Remove all formats from cell with value 18.86 in it. Is it formatted to left or to right? When to left, then it is interpreted as text by Excel.
Reply With Quote