Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
Hi all
I have a spreadsheet with a list of codes (about 6 digits). I want to compare the codes with a list and return a new code (v-lookup). The old codes mostly start with 00 or 000 but not all 004463 000547 and they are formatted as text in the V-lookup table but as special in the other list (im not sure what special is as a format). When comparing the v-lookup it does not work which I assume is because they are formatted differently. However if I change the Format from special to Text (so they are the same) I lose the zeros at the end so again the Vlookup will not work Is there a way of changing the format to text without losing the zeros Hope this made sense and any help is greatly appreciated. Kind regards Rexmann (running Excel XP) However the list of values is stored |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
try = text(C11,"000000')
"rexmann" wrote: Hi all I have a spreadsheet with a list of codes (about 6 digits). I want to compare the codes with a list and return a new code (v-lookup). The old codes mostly start with 00 or 000 but not all 004463 000547 and they are formatted as text in the V-lookup table but as special in the other list (im not sure what special is as a format). When comparing the v-lookup it does not work which I assume is because they are formatted differently. However if I change the Format from special to Text (so they are the same) I lose the zeros at the end so again the Vlookup will not work Is there a way of changing the format to text without losing the zeros Hope this made sense and any help is greatly appreciated. Kind regards Rexmann (running Excel XP) However the list of values is stored |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |