I will speak English too.
Select your destination cell - Right click - Format Cells - Number Tab - Custom - In the "type" field enter (£#.##0,00) ( Bold is unnecessary)


See attached.
The result IS A NUMBER as it is RIGHT ALIGNED in the cell. Text is always LEFT ALIGNED ( provided no manual alignment is applied)
And BTW please be careful when you give an example. In post # 20 you wrote Isn't there n extra zero ?

Attached Files

Custom Format.xlsx (8.9 KB, 2 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post