Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2010

Mon 20 Feb 2012, 16:24 Delegate Matt said...

Matt has attended:
Excel Intermediate course

Excel

How can you convert numbers to text string using formulas or macros. For example, if cell A1 contains $1,203.56 can cell A2 return "One Thousand Two Hundred and Three Dollars and Fifty Six Cents

Wed 22 Feb 2012, 10:27 Trainer Andrew said...

RE: Excel

Hi Matt

thank you for your question - I've found a Microsoft support article that goes into the subject in some depth including some sample code.

http://support.microsoft.com/kb/213360

Let me know if this does the trick.

Thanks,

Andrew

Wed 29 Feb 2012: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Manually rotating a 3D chart