Excel Function : DECIMAL

Download now!

Excel Function : DECIMAL

Category

Math and trigonometry

Description

Converts a text representation of a number in a given base into a decimal number

Microsoft Excel Reference Page

https://support.office.com/en-us/article/DECIMAL-function-ee554665-6176-46ef-82de-0a283658da2e

Syntax and Description of the DECIMAL Excel Function

syntax in java I am trying to use the Excel function DECIMAL in a Java program but I can't seem to get the syntax right. This is what I am trying to do: CellStyle cellStyle = workbook.createCellStyle(); DataFormat format = workbook.createDataFormat(); cellStyle.setDataFormat(format.getFormat("DECIMAL(16,10)")); This is what I have tried: CellStyle cellStyle = workbook.createCellStyle(); DataFormat format = workbook.createDataFormat(); cellStyle.setDataFormat(format.getFormat("DECIMAL<

About DECIMAL Excel Function

The DECIMAL function in Excel converts a binary number to a decimal number. This function is useful for working with numbers stored as text, such as those imported from a database.