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 |