Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cydney
 
Posts: n/a
Default Negative Zero (-0) Exporting to Excel

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
How do I show negative number in brackets using excel? Alex Excel Worksheet Functions 3 September 7th 05 08:52 PM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 June 22nd 05 11:26 PM
display negative values as a blank cell in Excel pherozeb Excel Discussion (Misc queries) 3 January 5th 05 04:40 AM
display negative values as a blank cell in Excel Pheroze Bharucha Excel Discussion (Misc queries) 0 January 4th 05 10:51 PM


All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"