ethercalc icon indicating copy to clipboard operation
ethercalc copied to clipboard

How to input number as text

Open liujunwei4321 opened this issue 4 years ago • 1 comments

In Excel I can set cell format to text, everything input is treated as text, including long number In Ethercalc I can manually add ' in the beginning of the cell to force text. Is there any way to set the cell format of ethercalc to force everything input treated as text, especially digits longer than 15?

I also noticed there is a "custom" cell format, any document about it?

liujunwei4321 avatar Dec 26 '21 12:12 liujunwei4321

This might help you understand custom  Localisation works, but currency still $/date/number format still US · Issue #513 · audreyt/ethercalc I don't know if there is a way to force it to format as text other than using the single quote '

| | | | | |

|

| | | | Localisation works, but currency still $/date/number format still US · I...

Installed ethercalc on Debian 8.7 (using npm install -g ethercalc). All works fine, the page comes up in German,... |

|

|

On Sunday, 26 December 2021, 23:05:20 GMT+10:30, liujunwei4321 ***@***.***> wrote:  

In Excel I can set cell format to text, everything input is treated as text, including long number In Ethercalc I can manually add ' in the beginning of the cell to force text. Is there any way to set the cell format of ethercalc to force everything input treated as text?

I also noticed there is a "custom" cell format, any document about it?

— Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android. You are receiving this because you are subscribed to this thread.Message ID: @.***>

eddyparkinson avatar Dec 26 '21 23:12 eddyparkinson