How to retrieve cell value as it is that is formatted as "%" ?

DiegoZoracKy / convert-excel-to-json

Convert Excel to JSON, mapping sheet columns to object keys.

MIT License

290 stars 92 forks source link

Open snymrova opened 2 years ago

snymrova commented 2 years ago

I have a sheet in which the column value is formatted to percentage, the value I am getting is without formatting, how do I get the value as it is.

Example: col1: 22.5% (Formatted as %)

Output: 0.225

What I want as output is: 22.5%

How to achieve that?