Convert General to number/percentage

[jackfox68]

Hi everyone,

When I export a report i get a list of percentages in a "General" format. When i change the format to "Number" it does not appear to act as a number, meaning I can't sum it or select cells and it provides the sum in the bottom of the status bar. Any help would be appreciated. I did a search in the forum but did not see anything helpful.

Thanks in advance for any help you can provide.

Brian

 

[Joe4]

It sounds like it is coming in as Text.

One quick way to convert it to number is to do the following:
- Select the column you want to convert (can only do one column at a time)
- From the Data menu, select Text to Columns
- Immediately click the "Finish" button.

This should convert all those values to numbers.

 

[vaskov17]

Use the 'value' function. If you want to convert the 'General' number in A1 to an actual number put "=value(a1)" in another cell

 

[jackfox68]

Thanks for the answers. I actually multiplied the column by 100 and it did what I wanted. I was just grabbing at straws. Thanks for the additional options I can put in my tool belt.