Page 1 of 1
[Solved] Number changed after entering it in table
Posted: Thu Feb 20, 2020 10:01 pm
by native
Created a new document with a table with 3 columns and twelve rows. Inserted the text .223, clicked in the next cell and the text I just entered changed to 0.22.
HELP!
Re: HELP!
Posted: Thu Feb 20, 2020 10:13 pm
by RusselB
Welcome to the Forums.
Did you format the column that the entry was entered? If you did, then what you see will change to look like what you used as a format. The actual entry itself will still be recognized as .223 so if you do any math with that number, the math will work with all 3 digits, not just the two being displayed.
Re: HELP!
Posted: Thu Feb 20, 2020 10:17 pm
by Bidouille
HELP is not good for a title. We knows that you need help.
Try a search in this forum on "number format recognition".
Re: HELP!
Posted: Thu Feb 20, 2020 11:14 pm
by native
Sorry, did not know what to put in the title area.
| Edit: I created another topic title for you. — MrProgrammer, forum Moderator, 2020-02-20 09:17 UTC |
Re: Number changed after entering it in table
Posted: Thu Feb 20, 2020 11:49 pm
by native
Thanks for changing the topic tile for me.
I did figure this out.
I highlighted all the cells in my table and unchecked the "Number Recognition" option and that fixed the problem.
(I've made this type of document before and never had this issue.)