Rounding excel file

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.

Developer

Developer Tools

Accepted answers

bsheremeta

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!

All comments

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?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335