Rounding excel file

[bsheremeta]

I have a big excel file with multiple columns and multiple data types (v_string and double) and I need to round every single cell whenever possible. 

Should I use something like multi-field formula and try to round with if statement? 

Thanks for all the help. 

[Luke_C]

Hi @bsheremeta based on your description a multi-field formula tool seems appropriate. You'll need to use a 'tonumber' function in conjunction with the rounding to handle the string fields. 

You could also transpose the data all to one column, then just round the value column and crosstab it back.

[bsheremeta]

I'm able to select all numeric fields within multi field formula, but my formula seem not to work - round([_CurrentField_],1). Do you know what may be the case?

[christine_assaad]

Hi @bsheremeta 

Are you creating new columns or updating existing ones? Could it be output data type? 

[bsheremeta · Accepted solution]

I got it figured out! Some of the fields I was selecting didn't have the necessary data. I selected all fields and used round(tonumber([_CurrentField_]),1) and it worked. Thanks!