Unanswered

Read from excel but commas not taken in

(0) Share

Report

Posted on by JackyGrealish

Hi,

I have an issue where I am using "read values from excel". In the excel sheet, it is formatted to have commas in the values for example 12,723 or 5,792 or 6,908 . The commas are to seperate the 1000 mark to the rest. Although my excel has the commas in, PAD still takes values as 12723 or 5792 or 6908. Any ideas on how to include the commas when taking the values?

Thanks 🙂

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

ZS440 262 on at

Like
a
(1)

Report
Copy link

Link copied!

@JackyGrealish
hi.
If read as a text value, commas are also included.
However, since it is a text value and not a number, it cannot be used in the calculation as is.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

edit: apologies. Didn’t see other reply. What that user said, haha.

Try the “copy cells as text” switch. I think it’s under the Advanced section of “read from excel”.

note: this reads the cells as they are currently seen, so if you have a number and not enough room on the column, you will get ######. So, use it carefully.

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

"note: this reads the cells as they are currently seen, so if you have a number and not enough room on the column, you will get ######. So, use it carefully. "

LOL.......so true.......ugh

Was this reply helpful? Yes No