Hi guys,
I have a User form that pulls data through from cells that are formatted the same but the displayed amount (£) looks different (I've attached an image)
I'd rather the values look as the do in the 'Rental Income' text box so there isn't a large gap between the £ sign and Number.
Any ideas why there are displayed differently if the sources are formatted the same?
I have a User form that pulls data through from cells that are formatted the same but the displayed amount (£) looks different (I've attached an image)
I'd rather the values look as the do in the 'Rental Income' text box so there isn't a large gap between the £ sign and Number.
Any ideas why there are displayed differently if the sources are formatted the same?