Hide the Formula Result and Display Only Number

[SUHAS KARHADKAR]

Respected all Excel Gurus,

Please find attached the Sample File.

I want to display only the Number in the Cell and Hide the Formula Result.

Kindly help.

Thanking you & Regards!

Suhas

[BMV]

It could be done only by custom format that change for every cell by VBA or manually. The format must be exactly "12,01" "7,50" "89,01"
but before you should convert text value do number.