How to cube a number in google sheets
How to insert special symbols in google sheets such as squared (ft²), cubed(ft³), degrees (°), etc.
Timecodes:
this video is going to lead you through
how to insert special symbols
in google sheets this comes up a lot for
me especially when using the squared or
cube symbol
in excel you can use font character
formatting to make a superscript or even
a subscript
so you don't really have that option as
of this recording date to do that in
google sheets
so a couple quick options you could use
carrots so you could just write
this feet carrot squared
and just call it done and say that's
good enough you can also use alt codes
and i'll include a bunch in this but for
instance the all code for
squared is 0178 so you could write feet
and then alt 0 1
7 8 and let that go and now you'll have
squared you can also use copy and paste
so down here for instance we have this
little squared
graph grab that with control c type foot
control v
for squared and you can also use a
function so we could write
equals let's put foot in
quotation marks and then we'll write
ampersand
care parens and then it was
zero one two seven eight
and prince um and uh actually i got that
wrong it's zero one
seven eight my bad zero one seven eight
hit enter
and that'll give you the foot squared
just like above
the formatting difference is only just
because i hadn't copied the formatting
down there so
we can take this formatting and put it
there so it's large as well
with character codes i have all of those
down here for
a whole bunch of different numbers
superscript numbers subscript numbers
mass symbols fractions currencies and
bullets
these character codes sometimes will
work with the alt
but they'll always work with the c-h-a-r
at least in all the systems i tested
if you test a system that doesn't work
in please let me know
Related queries:
how to cube a number in google docs
how to cube in google sheets
convert google sheets to apple numbers
how to square a number in google sheets
how to number in google sheets
how to change number format in google sheets
