J
Joseph Sichelstiel
I manipulate alot of data in order to make databases
(such as getting the left 5 characters of a column).
Whenever I make databases using formulas (and then copy +
paste special + paste values) it always formats the data
into text.
I usually need this data to be in number format, and the
only way to format this is to format the entire column
as "numbers," and then go into every single cell with
data and "manually" reset the formatting (I need to press
f2 to bring up the cursor, then press enter). This is
the only way to format this kind of text into numbers.
What is going on? Why can't I format these cells
normally, why do I need to go into every single one
and "manually" reset them?
(such as getting the left 5 characters of a column).
Whenever I make databases using formulas (and then copy +
paste special + paste values) it always formats the data
into text.
I usually need this data to be in number format, and the
only way to format this is to format the entire column
as "numbers," and then go into every single cell with
data and "manually" reset the formatting (I need to press
f2 to bring up the cursor, then press enter). This is
the only way to format this kind of text into numbers.
What is going on? Why can't I format these cells
normally, why do I need to go into every single one
and "manually" reset them?