I have a cell format of '0.0.0' set for column A.
In column B I have a CONCATENATE function
=CONCATENATE('the number: ',A1')
If I type '2.1.2' into A1, then B1 shows 'the number: 2.1.2'
If I type '2' into A1 it is re-formatted (properly) to 2.0.0, but the concatenate function shows 'the number: 2'
Is there a way to force the format to show up in the concatenate function?