Question Excel / Googlespreadsheet questions

[brannsiu]

Hi just a short one. How can I let the Excel / Googlespreadsheet to display in a way , for example 1100 instead of 1,100
by default it adds a comma which is something I am not accustomed to.

 

[rgd1101]

https://support.google.com/docs/answer/56470?co=GENIE.Platform=Desktop&hl=en

 

[tennis2]

Both programs default to 1100. In both programs, you're looking for "number format"

 

[Alabalcho]

In Excel - when you go to Format (select cells, <Ctrl>-<1>, select "Numnber" under Catogory, and clear checkmark on "Use 1000 separator"

 

[USAFRet]

Excel 2019 (and earlier)