Is there a solution to SUM only those cells that only match a currency format?
The column will conatin phone numbers with or without dashes and amounts.
###-###-####
##########
####.##
I can reformat the column to #.## but if for some dumb reason the ph# is not in standard format the some get's rather large.
Thanks.
The column will conatin phone numbers with or without dashes and amounts.
###-###-####
##########
####.##
I can reformat the column to #.## but if for some dumb reason the ph# is not in standard format the some get's rather large.
Thanks.