Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to add a decimal to the second to last digit on the parts order column. For example Parts Order is
PARTS +0080 I am trying to convert to PARTS +008.0
How do I change the format for this?
Left([Parts Order],Len([Parts Order])-1)&'.'&Right([Parts Order],1)
Left([Parts Order],Len([Parts Order])-1)&'.'&Right([Parts Order],1)