| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom format field
Hi
Maybe I am expecting too much. I have a field which has custom format 1234 000 000 OR 0000 000 000 After this field has been populated I want to copy and paste the data to another column. Of course it only reads the figures I input, is there a way I can use the data that is created eg 1234 025 252 OR 0032 584 456 Thanks Anne |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom format field
=TEXT(A1,"0000 000 000")
-- David Biddulph "enna49" wrote in message ... Hi Maybe I am expecting too much. I have a field which has custom format 1234 000 000 OR 0000 000 000 After this field has been populated I want to copy and paste the data to another column. Of course it only reads the figures I input, is there a way I can use the data that is created eg 1234 025 252 OR 0032 584 456 Thanks Anne |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom format field
Thanjk you
"David Biddulph" wrote: =TEXT(A1,"0000 000 000") -- David Biddulph "enna49" wrote in message ... Hi Maybe I am expecting too much. I have a field which has custom format 1234 000 000 OR 0000 000 000 After this field has been populated I want to copy and paste the data to another column. Of course it only reads the figures I input, is there a way I can use the data that is created eg 1234 025 252 OR 0032 584 456 Thanks Anne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CUSTOM FIELD FOR PIVOT | Excel Discussion (Misc queries) | |||
| CUSTOM FIELD OR SUB TOTAL IN PIVOT TABLE | Excel Discussion (Misc queries) | |||
| Custom Field label | Excel Discussion (Misc queries) | |||
| Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
| Pivot Table - Custom Row Field | Excel Worksheet Functions | |||
Hybrid Mode
