| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to format data in cells in VB
I have some data in a table access which have some fields writed in 00X
format (X is a number) and I want to write a function to write those fields to cells in a sheet in Excel in 00X format (0 is number 0). But I don't know code to write. Who can help me. Thank you very much (Canh thiu thi nhau muc) --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to format data in cells in VB
One option:
Let Excel handle the numbers for you and give the column a custom number format of 000 -- Rob van Gelder - http://www.vangelder.co.nz/excel "vhung " wrote in message ... I have some data in a table access which have some fields writed in 00X format (X is a number) and I want to write a function to write those fields to cells in a sheet in Excel in 00X format (0 is number 0). But I don't know code to write. Who can help me. Thank you very much (Canh thiu thi nhau muc) --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cells as zip code not working | Excel Discussion (Misc queries) | |||
| Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
| FormatCellsSpecialZip Code | Excel Worksheet Functions | |||
| Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
| Format Cells by code | Excel Worksheet Functions | |||
Linear Mode
