Converting numbers to text

The UK's most regular instructor-led training courses.
Training information: excel one day course london · Excel courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Gemma has attended:
Powerpoint Introduction course
Excel Advanced course

by - delegate Gemma [3 posts] (2008 May 12 Mon, 16:57) Reply

Hi,

Can you tell me if there is a formula I can use to convert numbers to text eg on an expenses form where you need to write the number as well as have the numberical representation.

I look forward to hearing from you.

Gemma

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Converting numbers to text

by - trainer Tracy platinum contributer [586 posts] (2008 May 13 Tue, 05:34) Edited on 2008 May 13 Tue, 06:14 Reply

Hi Gemma,
Try simply clicking on you number and go to Format Cells and change the option from number to text.

Another option would be to type the ' sign before you put the number in this would work as well
Tracy

RE: Converting numbers to text

by - delegate Andrew [3 posts] (2008 May 14 Wed, 11:56) Reply

[Caveat: I am a trainee, not a trainer]

Hi Gemma, it doesn't seem like Excel has a function to display numbers as words (e.g. £1 --> "one pound"), but people have written functions in VBA (the same language as macros use). Here is one example which works if you replace Dollars with Pounds and Cents with Pence.

Andrew

· Reasons Why VBA for Excel Training Fails
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Features of Microsoft Excel that assist in Analysis of Financial Data
· How to Create Better Excel Spreadsheets: Part Two
· How Excel Training Can Improve Your Company's Sales Process

Please browse our web site to find out more about
excel one day course london and other Microsoft training courses.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips