| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting from VBE
Hello all !
I need to format a cell from VBE... it must formattes as number with 2 decimals.. then i will insert in my work.. help me please !! byee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting from VBE
You can set a cell's number format in VBA: Code: -------------------- Range("A1").Numberformat = "0.00" -------------------- for example. pls123;696870 Wrote: Hello all ! I need to format a cell from VBE... it must formattes as number with 2 decimals.. then i will insert in my work.. help me please !! byee -- aflatoon Regards, A. ------------------------------------------------------------------------ aflatoon's Profile: 1501 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194853 http://www.thecodecage.com/forumz |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting from VBE
Try
Selection.NumberFormat = "0.00" "pls123" wrote: Hello all ! I need to format a cell from VBE... it must formattes as number with 2 decimals.. then i will insert in my work.. help me please !! byee |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting from VBE
A lot of times, it's easiest to record a macro and change the format. Then stop
recording and just steal the code you need. If I'm gonna do lots of recording, sometimes I'll even start a test workbook and record in there so that I don't damage anything important. pls123 wrote: Hello all ! I need to format a cell from VBE... it must formattes as number with 2 decimals.. then i will insert in my work.. help me please !! byee -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting from VBE
Record a macro formatting your
-- Regards Dave Hawley www.ozgrid.com selection. "pls123" wrote in message ... Hello all ! I need to format a cell from VBE... it must formattes as number with 2 decimals.. then i will insert in my work.. help me please !! byee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Find formatting in text in cell, insert tags around formatting. | Excel Programming | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
| Decimal Formatting in Windows English vs European Formatting | Excel Programming | |||
Linear Mode
