Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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??? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
decimal places within a formula | Excel Discussion (Misc queries) | |||
DECIMAL PLACES IN FORMULAS | Excel Worksheet Functions | |||
Changing default decimal places | Excel Discussion (Misc queries) | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions |