Click here to Skip to main content
15,671,149 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to change the current cell value into Text format by using which code that I will use..??

for exammple:


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..!!!

For a range A1:C20 then use this:

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

[EDIT]Code tags added - LOSMAC[/EDIT]
Share this answer
Maciej Los 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.
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!
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900