decimal places
Hi I have a reasonably complex model in Excel, but for some unknown reason
the package will not recognise any number i type in with a decimal place. e.g. recognises 3814 as a number, but not 3813.5, any ideas??? |
Go to Format/Cells/Number/ and set your decimal places Hope this helps -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=376328 |
What happens when you type 3813.5
Regards, Peo Sjoblom "Simon0009" wrote: Hi I have a reasonably complex model in Excel, but for some unknown reason the package will not recognise any number i type in with a decimal place. e.g. recognises 3814 as a number, but not 3813.5, any ideas??? |
All times are GMT +1. The time now is 11:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com