|
|
#6
03-20-2018, 07:53 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to add numbers on a given date | barexcel | Excel | 3 | 05-04-2017 05:12 PM |
 row numbers in excel
|
dawnnolan54 | Excel | 1 | 12-02-2014 04:28 PM |
|
Excel deleted numbers
|
ep2002 | Excel | 2 | 09-19-2014 04:04 AM |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
| Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
Windows 8 
Office 2016
Threaded Mode