| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tab delimiting numbers
is there a way to force a number to maintian it's 0's when tab-delimiting
eg 0080 i would like it to be returned as is when delimiting and not change to 80 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab delimiting numbers
=TEXT(80,"0000")
=TEXT(A1,"0000") Gord Dibben MS Excel MVP On Sun, 7 Sep 2008 07:01:01 -0700, EngelseBoer wrote: is there a way to force a number to maintian it's 0's when tab-delimiting eg 0080 i would like it to be returned as is when delimiting and not change to 80 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab delimiting numbers
how will this affect a number 12345 0r 123456
i tried formating the coloumn as 0000 and that forces 5 and 6 digets to 4 -- not good and if i make it 000000 then i get 000080 not what i want maybe i hope for too much ? "Gord Dibben" wrote: =TEXT(80,"0000") =TEXT(A1,"0000") Gord Dibben MS Excel MVP On Sun, 7 Sep 2008 07:01:01 -0700, EngelseBoer wrote: is there a way to force a number to maintian it's 0's when tab-delimiting eg 0080 i would like it to be returned as is when delimiting and not change to 80 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab delimiting numbers
No it doesn't. A format of 0000 will still display numbers greater than 4
digits properly. What steps are you following where you get only 4 digits? What version of Excel do you have? Regards, Fred. "EngelseBoer" wrote in message ... how will this affect a number 12345 0r 123456 i tried formating the coloumn as 0000 and that forces 5 and 6 digets to 4 -- not good and if i make it 000000 then i get 000080 not what i want maybe i hope for too much ? "Gord Dibben" wrote: =TEXT(80,"0000") =TEXT(A1,"0000") Gord Dibben MS Excel MVP On Sun, 7 Sep 2008 07:01:01 -0700, EngelseBoer wrote: is there a way to force a number to maintian it's 0's when tab-delimiting eg 0080 i would like it to be returned as is when delimiting and not change to 80 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delimiting when seperator is a comma & number is bigger than 1,000 | Excel Discussion (Misc queries) | |||
| Delimiting and Formatting | Excel Discussion (Misc queries) | |||
| delimiting w/multiple delimiters? | Excel Discussion (Misc queries) | |||
| Pasting data without the worksheet automatically delimiting it? | Excel Discussion (Misc queries) | |||
| Pasting from clipboard-how to control text-to-columns delimiting | Excel Discussion (Misc queries) | |||
Hybrid Mode
