Covert text cell in numeric cells

Hi JaumeBS,

This table has a Header Row, and a Footer Row. The Body Cells in column B are formatted as Text (aligned left).

The SUM is 0 (as expected).

Format Column B as Automatic or Number (select the Body Cells and Format Panel > Cell > Data Format > Automatic or Number).

The cells are now aligned right and the SUM is (correctly) 6.

Regards,

Ian.

Use the Value() function in an added temporary column to convert the values into numbers.

Copy the results, then set the Data format of the original cell to Automatic, select the first cell in that column, and go to the Edit menu and choose Paste formula results.

Select and delete the temporary column.

Regards,

Barry

Hi Jaume,

My Language & Region uses dot (.) as the decimal separator.

Does the CSV (Character Separated Values) document use dot as the decimal separator?

Does your Language & Region use comma (,) as the decimal separator?

That may be why Numbers thinks it is text.

Please tell us your Language & Region.

A screen shot of your table will help us to see what you see.

Regards,

Ian.

Hi Jaume,

Please post a screen shot of the CSV as it appears in a Numbers table. Remove all personal details before you take the screen shot.

Perhaps the cells include text characters to denote the currency symbol (such as the Euro symbol)?

Regards,

Ian.