Quote:
Originally Posted by bala_vb
Hi,
try this formulae, use replace function to M with "000,000". Here is the example assuming you have 44M in A1
=REPLACE(A1,3,1,"000,000")
all the best
|
Thank you! I am working with the formula, I think it's going to work - well, I'm going to make it work. I didn't realize until this morning that the data has two decimal places before the "M" so I'm trying to use the replace formula twice on the same cell to replace the decimal point with a comma, and then come in to replace the "M" with the appropriate number of zeros. If that's not possible I am going to have to roll this data into a few columns, replacing what I need to as I go. You've got me on the right track, thanks so much!