Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Converting numbers to text

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Converting numbers to text

Resolved · Low Priority · Version 2003

Reply Mon 12 May 2008, 16:57Delegate Gemma said...

Gemma has attended:
Powerpoint Introduction course
Excel Advanced course

Converting numbers to text

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

For upcoming training course dates see: Pricing & availability

Reply Tue 13 May 2008, 05:34 Edited on Tue 13 May 2008, 06:14Trainer Tracy said...

RE: Converting numbers to text

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

Reply Wed 14 May 2008, 11:56Delegate Andrew said...

RE: Converting numbers to text

[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.

Excel articles

· So what's new in Excel 2007?
· How To Use Freeze Panes In Excel 2007
· Excel Charts As Easy As Pie
· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Organisation At Your Fingertips - Take Control Of Your Life With Excel

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

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips