Hi all, Hope you are enjoying the festivities......
I am attempting to auto populate a form where each component of a value requires splitting into individual cells. Please see the attached attempt. My approach works ok if there are odd pennies, but not if the pennies are zero, 10, 20, 30....... I am trying to find a formula that will work in all scenarios. TIA.
Amount in figures
-
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Amount in figures
You do not have the required permissions to view the files attached to this post.
Nathan
There's no place like home.....
There's no place like home.....
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Amount in figures
This might work:
=IF($C2>0,LEFT(RIGHT(TEXT($B2,"#.00"),2),1),0)
It should force Excel to retain two characters to the right of the decimal point.
=IF($C2>0,LEFT(RIGHT(TEXT($B2,"#.00"),2),1),0)
It should force Excel to retain two characters to the right of the decimal point.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Re: Amount in figures
It does work, thankyou very much!
Updated with attachment for reference.
Updated with attachment for reference.
You do not have the required permissions to view the files attached to this post.
Nathan
There's no place like home.....
There's no place like home.....