| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMATING NUMBER FORMATS TO EXACT NUMBERS.
have a workbook with staff id numbers and all IDs are formated as '000000' in
that if you enter 132 in the range 400132 is dipayed so for me to convert it into values I have to paste in the notepad and then repaste back in the same range as values -paste special -values.) is there a way I can do the same repetative procidure in a workbook of four sheets in ranges through VBA? I TRIED =TEXT(A1"400") BUT THAT MEANS I HAVE TO PASTE BACK AS VALUES same cyle of doing the same repetative job which i want to eliminate (sheet1 rangeA1:A6000)-(F1:F60000) (sheet2 range A1:A6000)-(F1:F60000) (sheet3 range A1:A6000)-(F1:F60000) (sheet4 range B1:B500)-(D1:D500)-(G1:G500)-(J1:J500) Apreciates any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
| Conditional Formating Based on Formats Instead of Values | Excel Discussion (Misc queries) | |||
| Lookup and Match with not exact numbers | Excel Worksheet Functions | |||
| find an exact number in a different sheet and use the cell containing the number to output information | Excel Programming | |||
| look for the exact number | Excel Discussion (Misc queries) | |||
Threaded Mode
