converting numbers text

AI Training: For Busy Decision Makers & Professionals Book now

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

Converting numbers to text

resolvedResolved · Low Priority · Version 2003

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

Edited on Tue 13 May 2008, 06:14

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

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.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips


Server loaded in 0.11 secs.