Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've come across an issue I can't seem to understand or resolve. Would
appreciate it if someone could help me out. I'm getting financial data from an ODBC source and then performing a simple subtraction calculation of two fields. With the format set at 15 decimals, the 2 numbers are the same. When I subtract one from the other, in Access it returns "0". That's all just fine. However, when I copy that query result into Excel, the number is "-0". Why is that? It prevents me from creating a formula with an IF statement that something like " =IF(b1=0,0,4/2) ". I need the number to return 0, not negative 0. Helllp?? -- THX cs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I show negative number in brackets using excel? | Excel Worksheet Functions | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) |