How do I change the number of decimal places displayed in Excel

G

Guest

How do I change the number of decimal places displayed in Excel when
concantenating m calculation results with text? The normal format options do
not work. Example: I want 601.23423423A displayed as 601.23A. <TIA>
 
B

Bob Phillips

as an example

=TEXT(601.23423423,"0.00")&"A"

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automaticallychanging the number of decimal places displayed 5
Can you remove excess decimal places in Excel? 4
Addition in Excel 2
decimal places 2
Access stripping decimal places in query 1
Cell Swallows Decimal Places 5
Excel Stop Excel from displaying rounded values 4
Decimal Place goes crazy when using the "&" Sign. 4

Top