Ask Your Question
0

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 4.4.6.3 Libreoffice. I thought it might be a glitch in Libreoffice.

Al

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

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
0

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

Stats

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

Seen: 98 times

Last updated: Jan 18 '16