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.
|