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