formatting cells
Thanks for all the help!! I got one for ya:
How can I format cells so they have at most 2 decimals places? So, if it is a whole number, it will not add .00 at the end: So, 4.14 = 4.14, 2 = 2, not 2.00 Thanks all you guys! |
formatting cells
I can't think of a way of doing it purely by formatting, but you could use
=ROUND(A1,2) and format as General. That would round 4.142 to 4.14 and display it as 4.14, but it would leave 2 as 2 and display it that way. -- David Biddulph "prana1" wrote in message ... Thanks for all the help!! I got one for ya: How can I format cells so they have at most 2 decimals places? So, if it is a whole number, it will not add .00 at the end: So, 4.14 = 4.14, 2 = 2, not 2.00 Thanks all you guys! |
All times are GMT +1. The time now is 11:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com