| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format
hi,
i have a cell which currently has "=sheet1!A4" & "units". I would like to know how i can format this to where the number value in the cell contains a comma seperator. like if the value of A4 is 34,000, the result is "34,000 units" instead of "34000 units". thanks in advance, geebee |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format
=TEXT(Sheet1!A4,"#,000")&" units"
"geebee" wrote: hi, i have a cell which currently has "=sheet1!A4" & "units". I would like to know how i can format this to where the number value in the cell contains a comma seperator. like if the value of A4 is 34,000, the result is "34,000 units" instead of "34000 units". thanks in advance, geebee |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format
i have a cell which currently has "=sheet1!A4" & "units". I would like to
know how i can format this to where the number value in the cell contains a comma seperator. like if the value of A4 is 34,000, the result is "34,000 units" instead of "34000 units". Give this a try instead... =TEXT(Sheet1!A4,"#,##0")&" units" Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Decide comment format 'globally'? Restore format with ws_change? | Excel Discussion (Misc queries) | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Hybrid Mode
