Liliwen
Jun 8, 2012, 05:19 AM
I have a list of figures.. they a various and I need to calculate 50% in a separate column which I have done. I now need to feed the resulting list into a rather antiquated system in order to process the service I am providing.
The problem is this (my) system will not accept a number that returns as 3.125 (50% of 6.25 of course) in the fx window even though the actual cell reads 3.13 once I formatted the list to accounting and 2 decimal spaces. I can manually change each occurrence in the list of course but knowing how amazing excel is think there must be another way to globally amend the whole list.
I have dabbled with the 'roundup' function, looked briefly at 'ceiling' but neither has so far worked.
Any ideas would be hugely appreciated
The problem is this (my) system will not accept a number that returns as 3.125 (50% of 6.25 of course) in the fx window even though the actual cell reads 3.13 once I formatted the list to accounting and 2 decimal spaces. I can manually change each occurrence in the list of course but knowing how amazing excel is think there must be another way to globally amend the whole list.
I have dabbled with the 'roundup' function, looked briefly at 'ceiling' but neither has so far worked.
Any ideas would be hugely appreciated