Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Monday, October 05, 2015 – Permalink –

Format Numbers

It's your choice


OzGrid:
Custom Formats

If you need to format numbers that will be displayed connected to text, here is one way to do it:
  1. In cell A1, enter the text "You still owe the sum of".
  2. In cell A2, enter the number "5434".
  3. In cell A3, enter the text "for invoice # 2232 from 6/15/2001".
  4. In cell A4, enter the formula =A1&" "&TEXT(A2,"#,##0")&" "&A3.
You still owe the sum of 5,434 for invoice # 2232 from 6/15/2001

Excel Tips
Formatting concatenated numbers and text


Or:



Also:
Excel Format Tips

Also:
A very well produced examination of the subject by Jon Peltier:
Number Formats in Microsoft Excel


See all Topics

Labels: , , ,


<Doug Klippert@ 3:55 AM

Comments: Post a Comment