• Congratulations to the Class of 2024 on your results!
    Let us know how you went here
    Got a question about your uni preferences? Ask us here

spreadsheets.. (1 Viewer)

wallid

Member
Joined
Feb 18, 2004
Messages
160
Gender
Male
HSC
2004
if a ###### appears in a cell - widen
if comes in red - negative value


what else/???
 

rckl

Member
Joined
Mar 8, 2004
Messages
80
Gender
Male
HSC
2004
this symbol ######### mean, the cell is not wide enough to display the number, red mean negative values if u use the default format and layout
 

wallid

Member
Joined
Feb 18, 2004
Messages
160
Gender
Male
HSC
2004
when a number comes up in red...., -100


i saw it in a multiple choice some where i thought?.. is their anything else that i should know
 

CrashOveride

Active Member
Joined
Feb 18, 2004
Messages
1,488
Location
Havana
Gender
Undisclosed
HSC
2006
oh ok it depends on the formatting applied to the cell...if its on the default that wudnt happen but yeah if its on another option, if u were to type in -100 it would just appear as 100 but in red
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top