Click here to Skip to main content
12,253,633 members (54,637 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: MS-Excel VBA
I want to change the current cell value into Text format by using which code that I will use..??


for exammple:

Thisworkbook.Sheets("Jai").Cells(3,5).NumberFormat="General"


Pls give me the suggestion and tell me the shortcut key for that..???


because of 15-08 value should be changed into the Aug-08..!!!
Posted 27-Aug-12 5:52am
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

For a range A1:C20 then use this:

Range("A1:C20").NumberFormat = "General"

[EDIT]Code tags added - LOSMAC[/EDIT]
  Permalink  
v2
Comments
losmac 27-Aug-12 14:55pm
   
Maybe i'm wrong, but OP wants to format cell for date-time format, not general. In my opinion he/she doesn't need any macro to format single cell.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

What kind of suggestion, what kind of shortcut?

1) Select range of cells or single cell,
2) Click the right button of mouse on the selection,
3) Choose "Cell formatting",
4) Change formatting.

That's all!
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 27 Aug 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100