Forum Discussion

Fabiolus's avatar
Fabiolus
Occasional Contributor
17 years ago

Reading from Spreadsheet not transfering proper format

I have a spreadsheet that contains data being sent to a wsdl. On my original spreadsheet the ammount contains 4 digits after the decimal (1.1234) When uploading the information using the DataSource...
M_McDonald's avatar
M_McDonald
Super Contributor
17 years ago
Try a custom cell format in Excel :

0.#########

This will show only the number of digits that exist after the decimal. Only downside is that you get a decimal even if you enter an integer in the cell (eg., 77 will show 77.)