G
Guest
Hi
I have a financial spreadsheet that I imported from a CSV file. All of the
number cells are showing the number left justified, which I think means that
Excel sees them as text. However when I click on "Format Cells:Number", the
Category setting is "General". If I attempt to apply any of the procedures in
the help pages, like multiplying the content by 1 (to convert text to number)
that operation seems to fail as it does not result in producing a number
either.
How can I convert these cells to proper numbers that will respond to
formulas and conditional formatting?
Thanks in advance.
I have a financial spreadsheet that I imported from a CSV file. All of the
number cells are showing the number left justified, which I think means that
Excel sees them as text. However when I click on "Format Cells:Number", the
Category setting is "General". If I attempt to apply any of the procedures in
the help pages, like multiplying the content by 1 (to convert text to number)
that operation seems to fail as it does not result in producing a number
either.
How can I convert these cells to proper numbers that will respond to
formulas and conditional formatting?
Thanks in advance.