LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Excel formula and numbering

Dear all,

I have been trying to add number in excel 2003 with decimals, but some works
and others not. In format cells i put the decimal places to 3. Lets say i use
number 554.965 and excel takes it as 554965, but a number such as 38 excel
takes it as 38 normally,when I add both expecting to have 592.965, i get this
answer 555003.000, again when I make the numbers to use the 1000's separator
it gives me something like this 555003.0.000. Would you help me correct my
report?

Thank you in advance for your support and understanding.

Olivier
 
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
PO with sequential numbering with start / end numbering [email protected] Excel Discussion (Misc queries) 1 April 24th 07 03:38 PM
Excel 2000 numbering add-in Kevin Withers Excel Discussion (Misc queries) 4 March 21st 07 11:40 PM
Excel/VBA Automatic Numbering [email protected] New Users to Excel 1 February 8th 07 10:41 PM
Need Help with Excel page numbering uclabennett New Users to Excel 0 October 5th 05 04:55 PM
excel numbering add-in Fran Excel Discussion (Misc queries) 2 February 3rd 05 08:43 PM


All times are GMT +1. The time now is 01:57 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"