I am looking for an easy way to convert $M values to eliminate the 6 zeros. Thanks.
E ExcelHelp Mar 3, 2005 #1 I am looking for an easy way to convert $M values to eliminate the 6 zeros. Thanks.
S Sheila D Mar 3, 2005 #2 You could try something like this: =IF(RIGHT(A1,6)="000000",A1/1000000&"M",A1) unless someone has a better idea.... Sheila
You could try something like this: =IF(RIGHT(A1,6)="000000",A1/1000000&"M",A1) unless someone has a better idea.... Sheila
D Dana DeLouis Mar 3, 2005 #3 Another option: =TEXT(A1,"$ #,, ""M""") Another option would be to keep the value in the cell, and use a similar Custom format.
Another option: =TEXT(A1,"$ #,, ""M""") Another option would be to keep the value in the cell, and use a similar Custom format.
B Bob Tarburton Mar 3, 2005 #4 Another option: =TEXT(A1,"$ #,, ""M""") Another option would be to keep the value in the cell, and use a similar Custom format. Click to expand... Custom format $ 0,,\M
Another option: =TEXT(A1,"$ #,, ""M""") Another option would be to keep the value in the cell, and use a similar Custom format. Click to expand... Custom format $ 0,,\M
