Thread: How to format number the same way calculators do
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Lincoln Mark Lincoln is offline
external usenet poster
  
Posts: 227
Default How to format number the same way calculators do
Use two Format statements, and choose between the two based on whether
the number is an integer or not. If it's an integer, use
Format(yournumber, "0"), else use the format you described.

Reply With QuoteReply With Quote