Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Change Category Cell in vba

Friends,
How can I Change the category of only one cell, exemple: change of
"General" to "Text".
This is to look in cell the variable "00000000" and no 0
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Change Category Cell in vba

Select only the single cell and then pull-down:

Format Cells... Number and pick Text rather than general.
--
Gary''s Student - gsnu200722


"Ienidualc" wrote:

Friends,
How can I Change the category of only one cell, exemple: change of
"General" to "Text".
This is to look in cell the variable "00000000" and no 0
Thanks

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Change Category Cell in vba

Dear friend, thank you answer,
but will you take an exemple to me?
I need to change an exemple: cell "A" and cell "B".


"Gary''s Student" wrote:

Select only the single cell and then pull-down:

Format Cells... Number and pick Text rather than general.
--
Gary''s Student - gsnu200722


"Ienidualc" wrote:

Friends,
How can I Change the category of only one cell, exemple: change of
"General" to "Text".
This is to look in cell the variable "00000000" and no 0
Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change category width... ajayb Charts and Charting in Excel 2 March 1st 07 08:36 PM
Excel: Can I change Chart-title/category/value from a sheet-cell? femke Charts and Charting in Excel 4 October 24th 05 04:55 PM
Can not change Category Names for Axis Intellihome[_18_] Excel Programming 1 May 28th 05 07:56 PM
Can not change Category Names for Axis Intellihome[_13_] Excel Programming 0 May 27th 05 09:21 PM
Can not change Category Names for Axis Intellihome[_16_] Excel Programming 0 May 27th 05 09:21 PM


All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"