About 13 numbers entered into a cell automatically (& wrongly) reformatted

Post your questions, bug reports and suggestions here for PlanMaker 2016 for Windows.

Moderator: SoftMaker Team

Post Reply
ecbritz
Posts: 239
Joined: Mon Sep 14, 2015 9:45 am

About 13 numbers entered into a cell automatically (& wrongly) reformatted

Post by ecbritz » Thu Jul 26, 2018 10:44 am

When I enter about 13 numbers into a cell, it is automatically and wrongly reformatted by Planmaker. E.g. I might enter the following 13 numbers into a cell in column E, row 3: 7601160037089. Planmaker automatically changes this to 7,60116E+012. Why does this happen? How do I avoid this from happening? It happens in both Planmaker 2016 and 2018 it would seem. I am an experienced Softmaker Office user but new at using Planmaker.
Softmaker 2016 & 2018.

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7942
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: About 13 numbers entered into a cell automatically (& wrongly) reformatted

Post by sven-l » Thu Jul 26, 2018 1:06 pm

It is intended and works the same way in MS Excel. Very long numbers are displayed in a scientific way.

If the number is not used as a 'number' (order number, etc.) then you should enter it with a leading apostrophe as text.
Sven Leßmann
SoftMaker Software GmbH

Post Reply

Return to “PlanMaker 2016 for Windows”