14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→case: Number precision of Excel
| Line 147: | Line 147: | ||
raw data: 1234567890123456 | raw data: 1234567890123456 | ||
-> | -> | ||
* (numeric format) 1234567890123450.00 | * (numeric format 數值格式) 1234567890123450.00 | ||
* (general format) 1.23457E+15 | * (general format 通用格式) 1.23457E+15 | ||
* (text format) 1.23457E+15 | * (text format 文字格式) 1.23457E+15 | ||
== duplicate data == | == duplicate data == | ||