Ask Your Question

Spreedsheet won't accept 6E5, changes it to ###.

asked 2016-01-16 06:09:41 +0200

al74dart gravatar image

updated 2016-03-10 19:57:28 +0200

Alex Kemp gravatar image

I have tried to enter 6E5 in several spaces on my spreadsheet and every time I enter it, it gets changed to ### when I hit my enter key. It has accepted other 3 characters groups without a problem. For some reason it just won't accept 6E5. I am running an Apple computer with 10.9.5 Mavericks using version Libreoffice. I thought it might be a glitch in Libreoffice.


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-01-18 22:58:29 +0200

Edward gravatar image

Sounds like CALC thinks you're entering a number using scientific notation (if you increase the column width you'll probably see 6.00E+005). Make sure to format the cell as text (or use an apostrophe before the 6)

edit flag offensive delete link more

answered 2016-01-19 12:21:05 +0200

al74dart gravatar image

Changing the cells to text solved the problem. I would have thought the default would have been text.
Thanks, Al

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-01-16 06:09:41 +0200

Seen: 97 times

Last updated: Jan 18 '16