Excel convert text to numbers

To convert a text to number.

you can click on the yellow exclamation and choose convert to number.

this process can be applied to multiple rows at the same time. 

• Related Articles

• Exported excel figures convert text to numbers.

  Due to formatting requirements numbers get stored as text in Excel. in order to apply formulars to these texts you will need to convert them to numbers first. Method 1 This method only works in Excel. Step 1. to select the region, click on the column ...

• 10.0. Multiple Running Number Setup

  How do I setup Multiple Running Number Series? This is useful if you need more than one set of running number series. Let’s say if you have 2 sales departments, each needed to have their own set of running numbers, you can create them as follows. ...

• Weird character being displayed when exporting to CSV.

  If you have non english text (eg, chinese characters) in the data when you export to excel. the unicode characters will lose their formatting when you export to excel. you'll need to tell Execl to format the CSV for you. select unicode as the ...

• GST Rounding option

  By default, the system calculates the GST Amount of each line item before summing up each line item's GST Amount to form the Document total GST Amount. (The figure displayed in "7% GST" field of the document) If you would like to change how a ...

• How to Key in Grant from IRAS

  Scenario How can I Receive in the Grant from IRAS in to the OCi Accounting System Version 10Solution You can do it by creating a Income Account for doing this go and verify the Chart of Account first, if can not find then create a Income Account. ...