Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert number to text as displayed
I have some data that appears in cells as: $37,920.00, $719.45, $2,850,500.00.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert number to text as displayed
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert number to text as displayed
On Saturday, October 13, 2012 2:50:52 AM UTC-7, plinius wrote:
Il 13/10/2012 01:18, ha scritto: I have some data that appears in cells as: $37,920.00, $719.45, $2,850,500.00. In the Formula Bar these numbers look like: 37920, 719.45, 2850500. The cells are formatted as Currency. What I would like is to capture the characters that make up the cell appearance. I know that this would change the numbers to text which is also desireable. The goal is to merge them into a Word mailing form. Is there a way to change these numbers into text with dollar sign, commas, and zeros in decimal places without retyping them? =TEXT(A1,"$ 0,0.00") oward E. After seeing this solution, I believe I misunderstood the OP request. Howard |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert number to text as displayed
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number displayed as text difficulties | Excel Programming | |||
cell format text and data displayed like a number | Excel Programming | |||
Convert displayed number to absolute value | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
data imported into EXCEL as text displayed as exponential number | Excel Programming |