Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default dash

I need a column starting with 1-1 but it changes to a date. When I change
the format to text it isn't exactly what I need. Can you have a column that
remains constant as in a rank and then have the corresponding data copied to
that rank without having to retype all of the data for that entry?
 
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
Dash in format Mpls501sMan Excel Discussion (Misc queries) 4 April 25th 06 12:36 PM
Is there a way to not show a dash as a zero in Excel chart? Steve Charts and Charting in Excel 2 December 20th 05 06:39 PM
understanding dash dash in a excel formula ldebner Excel Worksheet Functions 2 October 31st 05 01:47 PM
how do i stop excel from changing a dash to a zero in a cell? green51 Excel Worksheet Functions 1 October 29th 05 01:46 AM
How to insert a repeating dash in phone numbers without dashes in. LemonLiptonTea New Users to Excel 3 February 5th 05 05:18 PM


All times are GMT +1. The time now is 03:47 AM.

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

About Us

"It's about Microsoft Excel"