How to get whole decimal number from a cell

Help Activities
, ,
1

Hi,

I need to get a whole decimal value from a cell
(ie) to get all the numbers after the comma (,) or (.) can able to see in the formula bar. whereas only 2 or 3 numbers will be visible in the cell.

so, when extracting and writing it in “write line” or another Excel file its writes only with visible numbers.

How to get whole numbers from a cell.

image

2

@Prasaanth_S1
Hello
What format is your number column in the the Excel? I tried same with text and general and writeline each row and entire value is printed.

1 Like
3

@Prasaanth_S1
If your Excel is saving the numbers in Number or Scientific, you will have to alter the template to show more decimal places, but text and general will show all regardless.

1 Like
4

Am getting Excel values in the “Accounting” format. So all the cell values I need to change the format to “Number” or “Scientific”.

5

@Prasaanth_S1

Please try using read range with raw values option…that way whole number might be coming

Alternately try using workbookread range

Cheers