audreyt / ethercalc

Node.js port of Multi-user SocialCalc
https://ethercalc.net
Other
2.97k stars 538 forks source link

How to input number as text #772

Open liujunwei4321 opened 2 years ago

liujunwei4321 commented 2 years ago

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?

eddyparkinson commented 2 years ago

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: @.***>