Timeline for Mail Merge messing decimal places
Current License: CC BY-SA 4.0
14 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
S Apr 26 at 22:31 | history | suggested | MT1 |
add tag formatting
|
|
Apr 26 at 13:28 | review | Suggested edits | |||
S Apr 26 at 22:31 | |||||
Apr 24 at 13:00 | vote | accept | BsAxUbx5KoQDEpCAqSffwGy554PSah | ||
Apr 24 at 12:59 | comment | added | BsAxUbx5KoQDEpCAqSffwGy554PSah | @jsotola No, the cell value is 8,1 insted of 8,0999999999999996. I can guarantee that. And this little deduction is not intented, so it is an error. | |
Apr 23 at 19:10 | comment | added | Charles Kenyon | Word pays no attention to the formatting of numbers in Excel. You must do the formatting in Word using switches and pictures. gmayor.com/formatting_word_fields.htm answers.microsoft.com/en-us/msoffice/forum/all/… | |
Apr 23 at 6:34 | answer | added | Emily | timeline score: 2 | |
Apr 23 at 3:25 | comment | added | jsotola |
It is tiresome to fix these errors ... those are not errors
|
|
Apr 23 at 3:22 | comment | added | jsotola |
8,1 becomes 8,0999999999999996 ... probably not ... the cell value is probably 8,0999999999999996 and is being displayed as 8,1
|
|
Apr 22 at 22:36 | review | Close votes | |||
May 9 at 3:03 | |||||
Apr 22 at 22:21 | comment | added | Mockman | Does this answer your question? Microsoft mail merge incorrectly formatting numbers | |
Apr 22 at 22:19 | comment | added | Mockman | Have you done a search? And what did you attempt to do to solve the problem? | |
Apr 22 at 20:11 | comment | added | cybernetic.nomad | Where are these numbers from? Are they the results of formulas. What is the formatting on these cells? Note that formatting numbers to display only one decimal value does not change the value in the cell, only what is displayed. Maybe convert the displayed value to text before doing the merge? | |
Apr 22 at 19:38 | history | edited | BsAxUbx5KoQDEpCAqSffwGy554PSah | CC BY-SA 4.0 |
edited title
|
Apr 22 at 19:29 | history | asked | BsAxUbx5KoQDEpCAqSffwGy554PSah | CC BY-SA 4.0 |