Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default Is 1451.40B equal to 1451.40 x 1,000,000,000?

Is 1451.40B equal to 1451.40 x 1,000,000,000?
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 169
Default Is 1451.40B equal to 1451.40 x 1,000,000,000?

In article , ?B?RXJpYw==?= wrote:
Is 1451.40B equal to 1451.40 x 1,000,000,000?
Does anyone have any suggestions?
Thanks in advance for any suggestions


Looks like you are short some serious context here. :)
Are you thinking that the 'B' means 'billion' (for one of the values of
billion) ? This might be so in (say) finance (as is often done using M for
million) ... but while common, it is still wrong. :)

You need to read it in context, ... and if possible, you should ask the
writer what they meant to say so everyone is clear. :) :)

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Is 1451.40B equal to 1451.40 x 1,000,000,000?

No, but 1.4514E+12 is.

Eric wrote:

Is 1451.40B equal to 1451.40 x 1,000,000,000?
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric


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
can I make cell "yes" equal 1, "no" equal 0 can I make cell yes equal 1, no equa Excel Discussion (Misc queries) 4 April 22nd 23 06:09 AM
IF - not equal to j.jansson[_2_] Excel Worksheet Functions 4 September 4th 07 05:11 PM
how to: have something equal Cx where x=8+ C4 Raget Excel Discussion (Misc queries) 9 August 11th 07 06:48 AM
Does not equal phil2006 Excel Discussion (Misc queries) 3 June 21st 06 09:58 AM
Getting 0 to equal 1 soxn4n04 Excel Worksheet Functions 9 November 30th 04 04:15 PM


All times are GMT +1. The time now is 02:41 AM.

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

About Us

"It's about Microsoft Excel"