Click here to Skip to main content
11,925,851 members (61,981 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:


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 6:52am
Rate this: bad
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]
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
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!

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
Web01 | 2.8.151126.1 | Last Updated 27 Aug 2012
Copyright © CodeProject, 1999-2015
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