### Text to numbers in CSV file, forumla popup

Posted:

**Tue May 10, 2016 7:05 am**Two points here, one is not a bug-

First, I've noticed when converting report numbers (all numeric) to a standard format using CONCATENATE, example: cell A2 is 12345 and cell B1 is 2015, I combine them as 201512345 I end up with a text output. Here's my process:

After updating the column, I then copy the formula results and paste them (w/o formula update) over the original numbers so I can delete the formula column.

The results are always text. This happens when I check the convert text to numbers box when pasting.

The only option I have to convert them to numbers is to save and close then reopen the file, where the convert text to numbers does actually work.

Using a GSC format does the same thing, except there is no text to number option upon reopening. I'd love to be able to work in these files as a GSC and then save the final product as a CSV.

Am I missing something or is this how it is supposed to work? I know in Libre Calc there is an apostrophe before the number to flag text, and the apostrophe can be removed via find & replace.

Next, the v.16 formula popup is irritating. It often blocks the cells I need to see in order to enter data for the formula. Is there a way to avoid this as was the case in v.15?

Thank you.

First, I've noticed when converting report numbers (all numeric) to a standard format using CONCATENATE, example: cell A2 is 12345 and cell B1 is 2015, I combine them as 201512345 I end up with a text output. Here's my process:

After updating the column, I then copy the formula results and paste them (w/o formula update) over the original numbers so I can delete the formula column.

The results are always text. This happens when I check the convert text to numbers box when pasting.

The only option I have to convert them to numbers is to save and close then reopen the file, where the convert text to numbers does actually work.

Using a GSC format does the same thing, except there is no text to number option upon reopening. I'd love to be able to work in these files as a GSC and then save the final product as a CSV.

Am I missing something or is this how it is supposed to work? I know in Libre Calc there is an apostrophe before the number to flag text, and the apostrophe can be removed via find & replace.

Next, the v.16 formula popup is irritating. It often blocks the cells I need to see in order to enter data for the formula. Is there a way to avoid this as was the case in v.15?

Thank you.