Ask Your Question

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

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

al74dart gravatar image

updated 2020-08-28 22:35:03 +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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-13 13:31:46.984837

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

Question Tools

1 follower


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

Seen: 174 times

Last updated: Jan 18 '16