RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Hi fellas, quick one I hope.
Is there a non Conditional Formatting way of representing text like this:
£299
£189.99
£250
£399.99
So if the number has a decimal place, give it one, otherwise don't display it.
Basically I don't want to see this: £299.00
Cheers!
Is there a non Conditional Formatting way of representing text like this:
£299
£189.99
£250
£399.99
So if the number has a decimal place, give it one, otherwise don't display it.
Basically I don't want to see this: £299.00
Cheers!