LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Metolius Dad
 
Posts: n/a
Default Numeric formatting problem

When a calculation goes out to 10 decimal places I can use the cell format to
limit it to 2 places. But when I add (cancatenate ?) text to that
calculation it goes out to 10 places again. How can I make this not happen.

example:
=1/3 shows 0.333333333333
=1/3 shows 0.33 when cell formatted to 2 decimals
=1/3&" ml/hr" shows 0.333333333333 ml/hr EVEN THOUGH THE CELL IS FORMATTED
to only 2 decimal places.

TIA for any help.
Sam
 
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
Conditional formatting with dates formula problem. [email protected] Excel Discussion (Misc queries) 8 March 5th 05 11:47 PM
Automatic formatting problem in Excel Hook Excel Worksheet Functions 2 January 14th 05 07:15 PM
Count and Sum with Conditional Formatting Problem pmahajan Excel Worksheet Functions 1 December 14th 04 05:30 AM
problem with formatting cell to date format Del Excel Worksheet Functions 7 December 8th 04 05:14 PM
Formatting Cell problem Jacob Excel Discussion (Misc queries) 2 December 4th 04 09:33 AM


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