Ask Your Question

How to show long numbers as text [closed]

asked 2014-10-28 18:00:05 +0200

juanc gravatar image

I have a column with large numbers, I want Calc to show them entirely. I have tried formmating the cells as text but it does not work.


thank you

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 2016-03-05 18:24:24.499404


I'm using @ as formatting. I don't want scientific notation. So annoying

juanc gravatar imagejuanc ( 2014-10-28 18:04:01 +0200 )edit

Having set the "@" format code in advance of entering the sequence of digits (you didn't show which one) Calc won't change anything. You wouldn't see an exponent part if not entered explicitly.

If you want to have a numeric format showing numbers without using the scientific notation you have to take care for a sufficient width of the column. Annoying? Having entered numerical values using more digits than can be handled by the internal format you will see a rounded value in any case.

Lupp gravatar imageLupp ( 2014-10-29 00:34:05 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-10-28 23:56:42 +0200

horst gravatar image

Calc will only show 15 digits -as all spreadsheets do- as real numbers. If you have longer numbers and want to perform calculations you are out of luck. If you just want to display a long number (e.g. serial numbers, credit card numbers or so) format the cell as text (as you did) or enter spaces (1234 3456 )or letters (S/N 09876) in the number and Calc switches to text.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-10-28 18:00:05 +0200

Seen: 3,381 times

Last updated: Oct 28 '14