Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formatting
I have a number showing in cell B2 as 00 00000 000 which is the format
required. When I view the same number in the formula bar it shows as 0000000000 and is sometimes even a digit short (removing the first zero) The format showing is affecting my VLOOKUP formula, please could someone help me by formatting the account number so it shows as 00 00000 000 in the cell and in the formula bar. Any help will be much appreciated. Thanks -- RMP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formatting
Format the cells as text and type the numbers in with spaces in the
appropriate places "RMP" wrote: I have a number showing in cell B2 as 00 00000 000 which is the format required. When I view the same number in the formula bar it shows as 0000000000 and is sometimes even a digit short (removing the first zero) The format showing is affecting my VLOOKUP formula, please could someone help me by formatting the account number so it shows as 00 00000 000 in the cell and in the formula bar. Any help will be much appreciated. Thanks -- RMP |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formatting
Thankyou for your response,unfortunately that is not an option I am able to
use as there are uoto 1500 entries. Do you have any other suggestions? -- RMP "bigwheel" wrote: Format the cells as text and type the numbers in with spaces in the appropriate places "RMP" wrote: I have a number showing in cell B2 as 00 00000 000 which is the format required. When I view the same number in the formula bar it shows as 0000000000 and is sometimes even a digit short (removing the first zero) The format showing is affecting my VLOOKUP formula, please could someone help me by formatting the account number so it shows as 00 00000 000 in the cell and in the formula bar. Any help will be much appreciated. Thanks -- RMP |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formatting
insert a column next to it
in C2 enter =text(b2,"00 00000 000") copy and paste to end of data copy column c and paste special values it is text that will show the same in the formula bar and the cell "RMP" wrote: I have a number showing in cell B2 as 00 00000 000 which is the format required. When I view the same number in the formula bar it shows as 0000000000 and is sometimes even a digit short (removing the first zero) The format showing is affecting my VLOOKUP formula, please could someone help me by formatting the account number so it shows as 00 00000 000 in the cell and in the formula bar. Any help will be much appreciated. Thanks -- RMP |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formatting
Excellent, just what i needed, thanks very much for your help.
-- RMP "bj" wrote: insert a column next to it in C2 enter =text(b2,"00 00000 000") copy and paste to end of data copy column c and paste special values it is text that will show the same in the formula bar and the cell "RMP" wrote: I have a number showing in cell B2 as 00 00000 000 which is the format required. When I view the same number in the formula bar it shows as 0000000000 and is sometimes even a digit short (removing the first zero) The format showing is affecting my VLOOKUP formula, please could someone help me by formatting the account number so it shows as 00 00000 000 in the cell and in the formula bar. Any help will be much appreciated. Thanks -- RMP |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formatting
If it is a number, then the formula bar will show the number, not any
formatting which you have applied. If you want to see spaces, and leading zeroes, then you'll need to treat the data as text, either by formatting the cell as text before you type the data in or by preceding the data with an apostrophe. -- David Biddulph "RMP" wrote in message ... I have a number showing in cell B2 as 00 00000 000 which is the format required. When I view the same number in the formula bar it shows as 0000000000 and is sometimes even a digit short (removing the first zero) The format showing is affecting my VLOOKUP formula, please could someone help me by formatting the account number so it shows as 00 00000 000 in the cell and in the formula bar. Any help will be much appreciated. Thanks -- RMP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Formatting | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
Number formatting | Excel Discussion (Misc queries) | |||
Number Formatting | Excel Discussion (Misc queries) | |||
Number formatting | Excel Worksheet Functions |