Hi
This is a bit of a stange one. I have some formula in a spreadsheet
and the results are currently showing with 2 decimal places e.g. 0.75,
1.25, 5.60. However I would like this to display without the decimal
places e.g. 75, 125, 560 without the need to include *100 in the
formula. Unfortunately it is not a percentage so I cannot use that
option as it then displays with the percentage symbol.
Anyone any ideas?



--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=529140