| 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 |
| 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 | |||
Threaded Mode
