View Single Post
 
Old 03-17-2014, 12:11 PM
moe moe is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Mar 2014
Posts: 4
moe is on a distinguished road
Default

I did find this when searching, could it be adapted for my sheet

=DOLLARDE(SUBSTITUTE(A1,"-","."),12)*12
Reply With Quote