CODEWITHSUNDEEP
exceldecimaldigit
Joseph s
Joseph s

Reputation: 1

Convert 6,4,3, even 2 digit numbers from import to 2 decimal price

I have been struggling to find a solution to this. I have a CSV file with an unusual pricing format and I need to update an eCommerce database with it.

The prices in CSV looks like this:

258662
349387
304
50

So, last two digits is the 2nd decimal. I need to mass process these prices like this:

258662 to 2586,62
86923 to 869,23
304 to 3,04
50 to 0,50

I hope I could explain my need properly.

Upvotes: 0

Views: 77

Answers (1)

FLIR31207
FLIR31207

Reputation: 73

simply divide by 100; assuming that all the prices are stored in column A of your Excel sheet and you want to have the new prices in column B, the formula would be, e.g. for cell B1: =A1/100

Upvotes: 1

Related Questions